Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Not what you were looking for? View more on this topic or Ask a question