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

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

44 Views

I have similar question related to the thread below.

mdx-expression-for-topn-condition-in-universe

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