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?
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?
In the LooKML where you have
dimension: bill_code {
type: number
}
Thank you so much!