Formula to multiply values in 2 columns

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?

bd255b57-50f9-47f2-9e86-1f94b4640acb.png
6f61c9ff-4e6e-4cfc-ad8b-9ba08099dd3f.png
257384c5-0098-429e-a276-d19052cb1616.png
0 4 1,864
4 REPLIES 4

Dawid
Participant V

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? 

Dawid
Participant V

In the LooKML where you have

dimension: bill_code {
type: number
}

Thank you so much! 

Top Labels in this Space
Top Solution Authors