Blank Data required

[Karthick30]

Hi,

I am having a column which has blank values. I don't want to remove that. I need to count that. So I used formulas like 

if(isnull(column),'NA',column) and if(len(column)>0,column, 'NA').. 

but still my table column is not showing NA as value.. showing blank ( - ) value

Anyway to fix this

[Or]

Assuming you are working within a table (not a pivot) and these are measures, those approaches should work as you expect (you could also use Coalesce(column,'NA')).

Could you elaborate on what exactly it is you're doing, in what object type and what context?

[stevejoyce]

why not just this?  i'll add a trim just incase its blank spaces...  if(len(trim(column))>0,column, 'NA')