Expression help with Max function.

[apthansh]

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.          

[sunny_talwar]

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))