2 Replies Latest reply: Nov 11, 2016 12:18 PM by Marcus Sommer RSS

    Nested Aggregation

    Alessandro Marini

      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