0 Replies Latest reply: Jun 20, 2017 2:01 AM by Sheetal Borchate RSS

    YTM Calculation

    Sheetal Borchate

      Hello,

       

      I want to calculate YTM target.

      Eg. If user select April month then FTM and YTM will be same. but when he select May there should be addition of 2 months target i.e April & May


      For The Month(FTM) Expresion


      =Count({<NDATE={">$(vMaxUDate)","NULL"},JDATE={"<$(vMaxUDate)"}>}distinct ET)*NOAUDIT

       

      YTM Expression


      =if(MONTH='Apr',count({<JDATE={"<=$(vMonthEnd)"},CY={"$(vMaxYear)"},CN={1},NDATE={"NULL"}>} distinct ET)*NOAUDIT,

      if(MONTH='May',(count({<JDATE={"<=$(vMonthEnd)"},CY={"$(vMaxYear)"},CN={1},NDATE={"NULL"}>} distinct ET)*NOAUDIT)

      +

      (count({<JDATE={"<=$(vMonthEnd)"},CY={"$(vMaxYear)"},CN={2},NDATE={"NULL"}>} distinct ET)*NOAUDIT))

       

       

      where vMaxUDate=max(DATE) is Unlink date

      CY is year, CN is Monthnum I am passing 1 in CN for April Month and 2 For May Month

       

      Need help !!!