Nested Aggregation

[alessandro_mari]

Hi everybody,

I have to calculate the max value of the following exspression but in sense it's not possible to use nested aggregation, how can I solve it?

(budget-

SUM({$<Type={"S"}>}

if(

(month(DateCalendar)<=Month(vDateSet) and year(DateCalendar)=year(vDateSet)

or month(DateCalendar)>=Month(vDateRolling) and year(DateCalendar)=year(vDateRolling))

,Amount)))

/

budget

Thanks in advance for helping

[sunny_talwar]

Nested aggregation? What are you trying to do? May be provide a sample with expected output

[marcus_sommer]

Maybe this:

max(aggr(

(budget-

SUM({$<Type={"S"}>}

if(

(month(DateCalendar)<=Month(vDateSet) and year(DateCalendar)=year(vDateSet)

or month(DateCalendar)>=Month(vDateRolling) and year(DateCalendar)=year(vDateRolling))

,Amount)))

/

budget,

YourDimensions))

- Marcus