need quick help with set analysis

[rohanmayekar]

following expression giving error,

=sum({< STDSalary-ActualSalary = {">=0"} >}STDSalary-ActualSalary)

but following works fine,

=sum({< Diffsalary = {">=0"} >}STDSalary-ActualSalary)    

requirement is to get 1st expression working as Diffsalary is dummy column i am using for testing purpose

Name	STDSalary	ActualSalary	DiffSalary
Josh	2020	3000	980
James	7000	7500	500
Ron	6500	7100	600
may	5000	5100	100
Lois	2700	2901	201
rock	990	1001	11
jaimey	990	878	-112
Lisa	900	800	-100
diana	1767	1600	-167
hamosh	2000	1800	-200
ali	1200	980	-220
daisy	2323	1200	-1123
linda	2000	200	-1800
alex	17899	15000	-2899

[sunny_talwar · Accepted solution]

The first one doesn't work because you are not allowed to use calculations/functions on the left hand side of the modifier... may be you can use this

=Sum({<Name = {"=STDSalary - ActualSalary >= 0"}>} STDSalary-ActualSalary)

or this

Sum(If(STDSalary - ActualSalary >= 0, STDSalary - ActualSalary))

or this

Sum(RangeMax(STDSalary - ActualSalary, 0))

[rohanmayekar]

Thanks For the help and explanation.