Skip to Content
Jun 30, 2010 at 03:28 PM

IF ELSE condition in Universe for Source: SAP-BEX query


I have similar question related to the thread below.


We are using B XI 3.1 version:

I have need to incorporate following formula in BO-Universe for SAP-BEX query

Margin Ratio = if(sum([Margin Indicator])=0; 0; sum([Profit])/sum([Margin Indicator]))

I know that we need to use MDX/XML tags <EXPRESSION> </EXPRESSION> for this.

Could anyone tell me how to incorporate the above formula in Universe.

Thank you in advance.

- Anil