Skip to Content

Dimension Member Formula

Hello Friends,

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.


Thanks

Ed.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Apr 12, 2016 at 03:02 PM

    Division works the same way as other arithmetic operations... What do you mean by not correct result? Can you show some screenshots?

    Add comment
    10|10000 characters needed characters exceeded