Skip to Content
0
Former Member
Jan 29, 2009 at 08:01 PM

Multivalue and calculation of % in an Universe object

30 Views

Hello,

I want to calculate a calulated measure in the Universe with the formula

((f_direct_metrics.incurred_loss_amt_ytd/f_direct_metrics.direct_earned_premium_amt_ytd) *100,0)

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