Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have two field like
B.Salary, P.F
10000, 1200
50000, 6000
12000, 1240
20000, 2400
i want output like these
B.Salary, P.F, Totall
10000, 1200, 11200
50000, 6000, 56000
12000, 1240, 14240
20000, 2400, 22400;
Can you please suggest.
Hi
In Script
B.Salary+P.F AS Total,
Front End add an expression
Sum(B.Salary+P.F)
Ideally more information would helpful, i.e. where you want the fields and if they are in the same table within the data model.
Mark
In Chart Expression
Sum(B.Salary)+Sum(P.F)
Or
[B.Salary]+[P.F]
In Script
Load
B.Salary,
P.F,
B.Salary+P.F as Total
From DataSource;
Regards
Raman