Question

Formula to multiply values in 2 columns

  • 10 January 2022
  • 4 replies
  • 220 views

Hello, 

 

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!