NDIV0 NODIM

[Former Member]

Dear experts,

Would you have come across a query formula such as this?

NDIV0 ( NODIM ( ( 'Cube % Flag' == 1 ) * 'Actual / Numerator' %A 'Actual / Denominator' + NOT ( 'Cube % Flag' == 1 ) * 'Actual / Numerator' ) )

Any idea how to interpret this?

Many thanks,

Alfonso

[Former Member]

Alfonso,

TO put it in IF else ..

If NODIM ( ( 'Cube % Flag' == 1 ) Then 'Actual / Numerator' %A 'Actual / Denominator'

Else 'Actual / Numerator'

Pls check

http://help.sap.com/saphelp_nw04/helpdata/en/03/17f13a2f160f28e10000000a114084/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/00/e8d13f7fb44c21e10000000a1550b0/frameset.htm

-Doodle

Message was edited by: Doodle

Message was edited by: Doodle

[former_member188975]

Hi Alfonso,

You can simplify it as:

If <b>A</b> equal to <b>1</b> then <b>B</b> %A (% share of )<b>C</b>.

If <b>A</b> not equal to <b>1</b> then <b>B</b>

NODIM removes any units from the key figure values and NDIV0 prevents error message or the Red X if a division by zero occurs.

Hope this helps...