cancel
Showing results for 
Search instead for 
Did you mean: 

Writing formula with boolean operators

Former Member
0 Kudos

Hi,

I need to write a formula that will, for a key figure, recognize if the cell is blank and if so convert it to zero. So for example,

if (keyfig = ' ') , then (keyfig = '0')

How do I do this using the boolean operators supplied to us for writing formulas and calculated key figures????

Thank you!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

OK....I need to check if a cell contains a "blank"....can I do that in Bex?

For example: if (KF = "") ??

What is the proper way to handle this in Bex?

Former Member
0 Kudos

Try the below formula in your report.

(KF == 0)*0

Regards, Siva

Answers (1)

Answers (1)

sbastien_francal2
Active Participant
0 Kudos

Hello CM,

Have a look at this:

http://help.sap.com/saphelp_nw04/helpdata/en/23/17f13a2f160f28e10000000a114084/content.htm

Please, remember to use the search option on this forum, as I think that a lot of threads already mention this.

Hope it helps,