Skip to Content

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

Can you really use Display String formula to test for NULL

I am trying to manipulate the Display String of a field throught the Format Editor. If a field is null, it should display "N/A", or "No data given", or anything else appropriate I might choose.

I can't get this feature to work and I'm wondering if there's a bug here. I'm using the following formula:

if (isnull() or trim() = "")

then "N/A"

else

Am I doing something wrong or is there a better way to do this?

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