Expression help

[apthansh]

=If(GetSelectedCount(LuCurrencyType3) > 0,

    num(sum(if([Expense Type]='Base Rent',

         If([Year of Expense] = max([Year of Expense]),  

           [Expense Amount (USD)]/Factors))), '$(varCurrencySymbol) #,##0'),

    num(sum(if([Expense Type]='Base Rent',

         If([Year of Expense] = max([Year of Expense]), 

           [Expense Amount (USD)]))), '$(varCurrencySymbol) #,##0'))

Here I am getting an error saying Nested Aggregation not allowed and I guess it is because of

If([Year of Expense] = max([Year of Expense]), 

How can I put this together.

[swuehl · Accepted solution]

Maybe try

If([Year of Expense] = max(TOTAL [Year of Expense]),

or specify what exactely you want to achieve and how your model & data looks like.

[sunny_talwar]

You need to add an aggr() function after your sum because of what you are trying to do.... Alternatively, may be you just need to use set analysis if your comparison of Year of Expense to Max(Year of Expense) doesn't change based on your dimensions?

[apthansh]

Thnak you very much.That helped.