6 Replies Latest reply: Jan 15, 2018 8:01 PM by Sunny Talwar RSS

    max value

    Prithvi K

      Please help. I am trying to calculate max value in the last 3months

      but nothing is shown when I use this below expression

      =max(Sum({<MonthYear={">=$(vStart)<=$(vEnd)"}>} sales ))

       

      vStart=NUM(year(Today())) & NUM(month(Today()),'00')

      vEnd= Date(Addmonths( Date(today(),'YYYYMM'),-3),'MMM-YYYY')

       

      eg:

       

      month                 sales

       

      Dec-2017             100

      Nov-2017             200

      Oct-2017              50

      Sept-2017            20