1 Reply Latest reply on Jan 30, 2019 10:54 PM by Adam Aliz

    To calculate YTD, QTD, MTD, YOY, MOM

    Adam Aliz

      Shinichiro Murakami San,

       

      Is it possible to achieve, YTD, QTD, MTD,YOY,MOM

       

      Whenever, the new data is coming it should auto populate the relevant things.

       

       

      The format should be like this

       

        FY18/19                   FY17/18             YTD Change     YTD  in %                                                     

      ______                   ________            ________         ________

       

        FY18/19                   FY17/18             QTD Change     QTD in %

      ______                   ________            ________         ________

       

        FY18/19                   FY17/18             MTD Change    MTD in %

        ______                   ________            ________         ________

       

        FY18/19                   FY17/18             YOY Change    YOY in %

      ______                   ________            ________         ________

       

        FY18/19                   FY17/18             MOM Change    MOM in %

        ______                   ________            ________         ________

        • 1. Re: To calculate YTD, QTD, MTD, YOY, MOM
          Adam Aliz

          YTD should calculate from          FY18/19        between         FY17/18

           

          QTD Should calculate from       FY18/19-Q4  between      FY18/19-Q3

           

          MTD Should calculate from FY18/19-January (until today) between FY18/19-December

           

          YOY Should calculate from Previous year FY18/19 April 2018 between FY17/18 April

           

          MOM should calculate from FY18/19-January (until today) between FY18/19-December