3 Replies Latest reply on Sep 25, 2018 8:23 AM by Mahfooj Khan

    Get last amount for YTD, MTD, QTD

    Haan Haan

      Hi

      I have a parameter and calculation field as such which identify the YTD, MTD, QTD

       

      [Period] = 'YTD' and year([Date]) = year('TODAY')

      OR

      ([Period] = 'QTD' and year([Date]) = year('TODAY'))

      and DATEPART('quarter', [Date]) = DATEPART('quarter', ('TODAY'))

      OR

      ([Period] = 'MTD' and year([Date]) = year('TODAY')

       

      Now, problem that i m facing is creating formula for:

      If the selection isOutcome should beFormula
      YTDthe amount for the last day of the year (prior to 'TODAY')?
      QTDthe amount for the last day of the quarter (prior to 'TODAY')?
      MTDthe amount for the last day of the month (prior to 'TODAY')?

       

      Thank you.