Exclude Column in nested statement

[Anonymous]

Hi All,

The below expression should ignore the field organization. I am trying to ignore the field organization, but i am getting this error.

Error: Error in expression:

Nested aggregation not allowed

= avg( aggr (Avg(  if( Year_Flag >0 ,

Aggr(FirstSortedValue({<Year={'>=$(=max(Year)-2)<=$(=max(.Year))'}>}Value, -Date),

Year_Org))),Value))

Thanks in advance

[sunny_talwar]

Where in your expression you think you are ignoring the field organization?

[Gysbert_Wassenaar]

Perhaps like this:

= avg({<organization=>}

     aggr(

        Avg({<organization=>}

            if(Only({<organization=>}Year_Flag) >0

                ,Aggr(

                     FirstSortedValue({<organization=,Year={'>=$(=max({<organization=>}Year)-2)<=$(=max({<organization=>} Year))'}>}Value, -Date)

                     ,Year_Org

                 )

             )

        ),

    Value)

)