Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi Sona,
Try like below
=Sum(Aggr(Sum( If(MonthEnd(Link_Date)=Monthend(DOJ),YearlyValue)),EmpCode))
Thanks. Working.
Can we convert the same to Set Analysis.
=Sum(Aggr(Sum( If(MonthEnd(Link_Date)=Monthend(DOJ),YearlyValue)),EmpCode))
Thanks.
@sona_sa may be below
Sum({<EmpCode ={" =MonthEnd(Link_Date)=Monthend(DOJ)"}>}YearlyValue)