Skip to Content

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

To display DB blank values as NA

Hi All,

In my report ,the db field consists of both zero and blank values.i want zero values to be displayed as 0 and blank values alone to be displayed as NA.

If i checked the option "Convert Database values to Null" ,all the values "both zero and blank" gets converted to zero or the default value.

i also tried using IsNull function..the blank values doesn't get any change.

Can anyone please help me to solve this issue?

Thanking you in Advance,

Vinoth

replied

Did you try the formula like

if isnull(field)=true then
"NA"
else
totext(field)

Regards,

Raghavendra

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