1 Reply Latest reply: May 27, 2018 5:34 PM by Manish Kachhia RSS

    Max Date Month

    Mariam Ovasheli

      Hi,

      I Want to sum MAX MONTH DATE with date field. I use This formula

      sum({<Month={'$(=Month(max(Date)))'}>}Volume) and It does not work can you please Tell me What to do?

        • Re: Max Date Month
          Manish Kachhia

          SUM({<Month = {"$(=Month(Max(Date)))"}>}Volume)

          or

          SUM({<Month = {"$(=Month(Max({1}Date)))"}>}Volume)

          or

          SUM({<Date = {">=$(=MonthStart(Max(Date)))<=$(=MonthEnd(Max(Date)))"}>}Volume)

          or

          SUM({<Date = {">=$(=MonthStart(Max({1}Date)))<=$(=MonthEnd({1}Max(Date)))"}>}Volume)

           

          I am assuming that Month field is having same format as the MonthNames variable's month format.

           

          SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';