Formula to multiply values in 2 columns

  • 10 January 2022
  • 4 replies



I’m trying to add a calculation to multiply values in 2 columns but the calculation is showing this error. I’m using the “Table Calculation” field under the “Custom Fields” section. 


I’m trying to add a 3rd column that multiples values in the “Bill Code Code” field and “Visit Unit Qty Sum” field. Is this possible?



This topic has been closed for comments

4 replies

Userlevel 7
Badge +1

Make sure the Bill Code dimension has type:number

Hi Dawid, 


Thank you for your response. Where would I need to go to change the bill code dimension type to number? 

Userlevel 7
Badge +1

In the LooKML where you have


dimension: bill_code {
type: number


Thank you so much!