Hi we have a FR report built on ASO cube. The report has calculations using FR functions VarPer and Var, which are giving correct results.
We want to move Var and VarPer to ASO outline
Var = [Actual] - [Budget]
VarPer = ([Actual] - [Budget]) / [Actual] * 100
= ([Actual] - [Budget]) / [Actual]
We are having issues with VarPer formula ...its not giving correct results.....what is the correct formula for VarPer?
further we noticed that the MDX formulas having division are not giving correct results.
Loss Expenses 44466061.54
Premiums Earned -421792129.1
Loss Expense Ratio -0.204727934
Loss Expense Ratio = [Loss Expenses] / [Premiums Earned]
Loss Expense Ratio = -10.5421743% when we calculate it manually.......we get corrct results,......
how to resolve it
Scoring disabled. You must be logged in to score posts.