3 Replies Latest reply: Jan 3, 2017 7:12 AM by Maciej Rodak RSS

    Problem with sum

    Maciej Rodak

      Hi,

       

      I would like to have the sum that shows only values for the YearMonth that has maximum value. This YearMonth is generated by mastercalendar. I don't know what is wrong, but id doesn't work. if I take Max(YearMonth) separately it shows proper value i.e. 201609, but if it is in the formula shown below - it doesn't work.

       

      sum(${<YearMonth=${Max(YearMonth)}>}Amount)

       

      Maciek