Formula in BEx Query Designer

[Former Member]

Hi Friends,

I have a requirement to create a formula, that checks the following condition.

1) if Keyfigure A is 0 and Keyfigure B is 0 then the Value of this Formula should be null(blank space).

2) if Keyfigure A is 0 and Keyfigure B is NOT 0 then the Value of this Formula should be 0.00

i have written the following

1) I dont know how to display blank space...

2) (A == 0) AND (B == 0)*0

Can you please tell me how to achieve this (1) and if the (2) formula is right.

Thanks in Advance.

Regards,

Vinaya Paulraj.

[Former Member · Accepted solution]

Hi

It is not possible to display blank space instead you can enable Zero suppression but make sure the Zero supression will also supress the second result because as you had given you need 0 as the output for the second formula. Else instead of Zero for the second option make it as 0.001 so that the second result will not get supressed.

2) if Keyfigure A is 0 and Keyfigure B is NOT 0 then the Value of this Formula should be 0.00

2) (A == 0) AND (B NE 0)*0 (B Not 0 is the condition you specified so use not equal to)

Regards

M.A