Dimension Member Formula
I have created a dimension formula on account dimension.
The formula is very simple. I have 2 nodes in account dimensions, Revenue and Expenses.
I have created a dummy Account - Profit.
Profit = IIF([REVENUE]=0,0,([REVENUE]-[EXPENSE])/[REVENUE])
the calculation does not give me correct results, though its not throwing me any errors.
However if I just do [REVENUE]-[EXPENSE] = calculation looks good.
If I change it to [REVENUE]-[EXPENSE]/100 - calculation looks good.
There is something in the division which is not working if I use account nodes.