topic Nested Aggregation in Visualization and Usability

Nested Aggregation

alessandro_mari — Fri, 11 Nov 2016 15:11:45 GMT

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 — Fri, 11 Nov 2016 16:50:54 GMT

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

marcus_sommer — Fri, 11 Nov 2016 17:18:58 GMT

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