Formula Builder: BEx: How do you incicate a blank??

[Former Member]

Good day

Please help?

In excel you indicate a blank in a formulae as " ", how would you handle this in formula builder in a BEx formula?

thanks

Cj

[Former Member]

Answered. Thanks

[Former Member]

Hi There

Thanks for the quick response. Unfortunately it did not work... What we have is::

KF1 KF2 Answer

100 100

50

KF1 + KF2 = answer

We want an answer to be "blank" in the second line when KF2 is also blank. In excel you would have had the formulae ie: "=if('cell for KF2' ="",""...)

Your help please?

[former_member205352]

Try the below for your Answer Formula :

(KF2 == 0) * 0 + (KF2 <> 0) * (KF1+KF2)

Its KF2 ne 0 I am not able to put ne symbol which is greater than and less than together.

Hope this helps.

Edited by: Praveen G on Oct 3, 2008 7:34 AM

[former_member205352]

You can use 0(zero) to display as blank.

Make sure in query properties you dont display Zero.

Hope this helps.