Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
You cannot Sum the Strings first thing. To get into work. Perhaps
Sum({<Column -= {'N/A', 'n/e'}>} Measure)
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,
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?