Hello,
Does anyone know how to create a calculation in Fusion Analytics Warehouse to calculate weighted average?
In my example, I have a table displays invoiced amount, unit price in rows and quarter in columns.
I wrote a calculation "(Invoiced amount*unit price)/Invoiced amount" but it doesn't work.
Any help is appreciated. Thank you.