How to Add More Values within same Calculated Column

[#1]

Hi All,

Below is a Sample Data i have:

Names	Values	Values2
jk8912	10	20
Nami001	-	100
mo024	2000	4000
hon343	-	50
brt110	2500	5000

Output that i want

Names	Values
jk8912	12
Nami001	50
mo024	2000
hon343	25
brt110	2500

How to Calculate only Rows that are Null and Assign 50% of a number we get on (Values2 Column), and it must not affect existing Numbers under (Values column).

[sunny_talwar]

Front end solution:

[#3]

Hi Avinash,

so the problem is now my Column is a Calculated one,

so how do i calculate for both

e.g: Sum(Values)

ur Solution:

if(len(values)<=0,Values2/2,values)

so how do i add the to methods in?

Thanks

[avinashelite]

Hi,

try the in expression level or else , in the script create two separate columns like:

LOAD Names,

if(len(values)<=0,Values2/2,values)  as Values_without_Null,

values,

value2

from table;

so if you don'e want to show null values then use Values_without_Null column , when you want to calculate the sum

then use values column sum(values) so that both the things are well separated

[#5]

Hi,

this what i've applied:

if(len(values)<=0,value2/2,values)

and Hidden the Nor Summation Column and Activate this one to automatically assign Values.

this works.

Thanks.

[avinashelite]

cool, if you have got the answer can you please mark it as answered and close this thread