To sum in script

[#1]

I have 3 columns like basicpay, hra, Variable pay I have to add these 3 columns .But while using sum function it accepts only 1 parameter.Please help  me find out the code  which I want  to be done in  script and to display the values in the dashboard...

Basic	HRA	Variable pay	Total
4000	3000	1500	8500

[saniyask]

Hi,

You can do this in the Dashboard or frontend.

Try sum(Basic) + Sum(HRA) + Sum(Variable Pay)

regards,

Saniya.

[surendraj]

try with rangesum

rangesum(Basic,HRA,Variable pay)

[#4]

I want to calculate individual sum for each employees.

Basic	HRA	Variable pay	Total
4000	3000	1500	8500
5000	2500	1500	9000
7000	4000	2500	13500
12000	5500	1000	18500

[Anonymous]

Why  not use sum(Basic) + Sum(HRA) + Sum(Variable Pay) group by employee??

[yoganantha321]

Priya,

Simply try with the following expression

Aggr(Sum(Basic+HRA+[Variable Pay]),EmpID)

I got the output as below

as you needed.........

I think it is useful

[#7]

I want to implement this in script backend..how?

[Anonymous]

You can use either of group by or rangesum

[Anonymous]

Hi ,

Direcly use this fields and create new field like-

Basic + HRA+ Variable Pay as Total

If you need do group by,You will get expected result.

Thanks

Paridhi

[yoganantha321]

priya,

Just do like this

LOAD EmpID,

     Basic,

     HRA,

     [Variable Pay],

     Basic+HRA+[Variable Pay] as Total

FROM

(ooxml, embedded labels, table is Sheet1);

Note: if you have many values for single employee just use group by employee id