Data function manipulation

[Former Member]

Hi

I'm using the NDIV0 data function in two of my queries. However, in cases where an 'X' appears in the report, users want to see '1' instead.

I can use transaction RCUSTV4 to change the BEX value, but I'm afraid it will change it globally and users don't want this '1' number to show on all the other reports.

Is there a way to change this display and make it work for only the two queries in question?

Thank you in advance,

Erika.

[Former Member]

Arun

I tried a Condition.. but I'm confused:

In the Conditions screen, I can choose either 'on or all Key figures', and give the range (between, equal to, etc) and then there is a variable text box.

Where can I set the condition about the denominator and say if it is indivisible, replace X with 1?

Thanks

Erika.

[former_member184494]

Erika,

instead of changing at the global level , see if a conditional IF statement will do the trick - either check for the denominator or check for the result using the conditional statement and appropriately change the display..

Arun