Script for total salary

[Kohli]

I have Table Employee...

E.ID, Emp Name,  Month, Year, Salary

101, Hari, Jan, 2016, 15000

102, Kiran, Jan, 2016, 17000

101, Hari, Mar, 2016, 14000

107, Prem, Apr, 2016, 12000

108, Ashok, July, 2016, 18000

101, Hari, Feb, 2017, 15000

I want find the toata salary of Hari.

[kaushiknsolanki]

Try this,

Sum({<[Emp Name] = {"Hari"}>}Salary)

Regards,

Kaushik Solanki

[Kohli]

Is it possible Sum(<{[ E.ID]={"101"]>}Salary);

[kaushiknsolanki]

Yes why not.

But correct your expression as below.

Sum({<[ E.ID]={"101"}>}Salary);

Regards,

Kaushik Solanki