Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Writing formula with boolean operators


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!

Former Member
Former Member replied

Try the below formula in your report.

(KF == 0)*0

Regards, Siva

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question