topic Re: Blank Data required in App Development

Blank Data required

Karthick30 — Wed, 15 Jun 2022 15:08:53 GMT

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

Re: Blank Data required

Or — Wed, 15 Jun 2022 15:12:03 GMT

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?

Re: Blank Data required

stevejoyce — Wed, 15 Jun 2022 15:15:20 GMT

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