8 Replies Latest reply on Feb 10, 2019 8:43 AM by Shinichiro Murakami

    Month on Month analysis and spend calculation

    Willium Fox

      Dear All,

       

      I have came up with this stated issue mentioned below.

       

      I need to input a comparison of spend between two different dates. That means today spend need to be compared by last month end date spend.  Example shown below

       

       

      01/01/2019 Spend - 1500

      01/20/2019 spend - 2000

      01/26/2019 Spend - 5000

       

      All the above figures need to be compared and insert a difference from the spend of 12/31/2018

       

      07/01/2018 Spend (Need to be compared with the spend of 06/30/2018)

      05/20/2018 spend - (Need to be compared with the spend of 04/30/2018)

      02/26/2018 Spend - (Need to be compared with the spend of 01/31/2018)

       

       

      Thank you very much