Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Where in your expression you think you are ignoring the field organization?
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)
)