I want to calculate a calulated measure in the Universe with the formula
I was thinking that I will get a percentage values since I am multiplying by 100. When aggregation level is set to NONE, I get MULTIVALUE#, when it is SUM the figure is too large and does not represent a % less than 100. What aggregation should I use.
I plan to use this calculated measure in the Xcelsius dashboard using QAAWS