Dealing with N/A or n/e

[Anonymous]

Hi All,

I have the following two exceptions all across my data which is in multiple columns:

(a) N/A and

(b) n/e.

Now , i have to sum all the columns in a new column, but i am not able to do so because of N/A and n/e. I have tried to replace these with '' (i.e. a blank value) but still the same result. i have also tried to convert this to a number using the Num function, but no success there as well. Request you to please help me with this. Many thanks,

[Anil_Babu_Samineni]

You cannot Sum the Strings first thing. To get into work. Perhaps

Sum({<Column -= {'N/A', 'n/e'}>} Measure)

[mdmukramali]

Hi Anand,

extend to loveisfail‌ reply,

suppose if you have 5 columns and you want to create a new column which is addition of all five columns

then you can try :

Sum({<Column1-={'N/A','n/e'}>} Column1)

+

Sum({<Column2-={'N/A','n/e'}>} Column2)

+

Sum({<Column3-={'N/A','n/e'}>} Column3)

+

Sum({<Column4-={'N/A','n/e'}>} Column4)

+

Sum({<Column5-={'N/A','n/e'}>} Column5)

if it's not helpful then attach sample data file.

Thanks,

Mukram,

[t_chetirbok]

let me ask you this:

are you working in script?

if you have Value1 and Value2 columns, you want create a new column Value = Value1 + Value2

Is it correct?