Skip to Content

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

remove null & empty values

I created a report with multiple fields. I would like to create a generic formula in which it evaluates all the values and if it found a null or empty value it will be replaced by a 'N/A'. I was searching in the forums and I found the following formula

if (isnull() or ( ='')) then

"Display the required text"

else

when I tried to use it i had an error that the value must be boolean. Is there is a way where I can change all the fields as string?? and a assign "N/A"

or

how can I assign a "N/A"to a boolean field??

also I have approx. 140 fields to evaluate, does the formula can be generic or I will need to create a formula for each variable??

thanks

Former Member
Former Member replied

Hummm... That doesn't make sense to me...

Try creating a new report against the Excel spreadsheet, and just drop all of the fields in the Detail format. Do you see all of the values?

Does the current report have any suppression logic?

HTH,

Carl

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