21 Replies Latest reply: Jan 3, 2018 7:14 AM by Sunny Talwar RSS

    Simple Last 3 Months sale set Expression

    zahid Rahim

      Dear Experts,

       

      I am trying to get last 3 months sale but getting only the date selected one day sale. i am using below expression:

       

      SUM({<TRX_DATE = {"$(='>=' & v3MonthsBackDate)"}>}

      (IF (TYPE = 'CM', QUANTITY_CREDITED , QUANTITY_INVOICED)/ IF(isnull(LTR_CV_RATE),1,LTR_CV_RATE))

      )

       

      where v3MonthsBackDate is a variable with below syntax:


      =(ADDMONTHS(Max(TRX_DATE),-3))


      Regards,


      Zahid Rahim