Display NA if Value is 0 or Null

[KP_1990]

I want to display 'NA' if my field value is either 0 or Null(-)  I tried using len function as well as IsNull function but it doesn't seem to work out both the conditions it works for either one.

eg:  if (Len(A)< 1,'NA',A) or  if(isNull(A),'NA',A)  it doesn't display NA if value is 0 but works if its Null

Can anyone please help me out with a condition that displays NA in both the cases i.e. 0 or NUll ??

[Vegar · Accepted solution]

if (Len(A)>0,A,'NA') or  if(A=0,'NA',A)