Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I put the below expression in Text Object
I know max(NoOfMonthsCY) is throwing it off..ID is the PK.
=sum(if(StartdateYear = EndtdateYear,ExpenseAmountLocal*NoOfMonthsnew,
if(StartdateYear<=year(today()),
if(EndtdateYear>=year(today()),ExpenseAmountLocal * max(NoOfMonthsCY)))))
Thank you.
Not entirely sure of what you doing, but may be this?
=Sum(
Aggr(
If(StartdateYear = EndtdateYear, ExpenseAmountLocal*NoOfMonthsnew,
if(StartdateYear<=year(today()),
If(EndtdateYear>=year(today()), ExpenseAmountLocal * max(NoOfMonthsCY)))), PK))