Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this,
Sum({<[Emp Name] = {"Hari"}>}Salary)
Regards,
Kaushik Solanki
Is it possible Sum(<{[ E.ID]={"101"]>}Salary);
Yes why not.
But correct your expression as below.
Sum({<[ E.ID]={"101"}>}Salary);
Regards,
Kaushik Solanki