Aggr Expression

[sona_sa]

Hi,

What is wrong in this expression :

=Aggr(Sum( If(MonthEnd(Link_Date)=Monthend(DOJ),YearlyValue)),EmpCode)

I want sum of salary of EMPCODE, Who has joined in End of That Month DOJ wise.

Thanks.

[lironbaram]

the expression above returns a virtual table 
of empcode and the expression value 
If you want to get the total number you need to wrap it by another sum function

[MayilVahanan]

Hi Sona,

Try like below

=Sum(Aggr(Sum( If(MonthEnd(Link_Date)=Monthend(DOJ),YearlyValue)),EmpCode))

[sona_sa]

Thanks. Working.

Can we convert the same to Set Analysis.

=Sum(Aggr(Sum( If(MonthEnd(Link_Date)=Monthend(DOJ),YearlyValue)),EmpCode))

Thanks.

[Kushal_Chawda]

@sona_sa  may be below

Sum({<EmpCode ={" =MonthEnd(Link_Date)=Monthend(DOJ)"}>}YearlyValue)