2 Replies Latest reply on Nov 3, 2016 9:11 AM by Arihant Jain

    Amount difference between two dates

    Arihant Jain

      Hello,

       

      I want to see the difference in total amount between two date. For that I have created two parameter, once as "Latest snapshot date" and another as "Prior Snapshot date" and also created a calculated filed to link "Total" column to get the desired result.

       

      To get the difference, I have created a calculated filed "Latest week vs. Prior week" and formula is  - [Latest Week total]-[Prior Week total], but it is not giving any value.

       

      I have attached the workbook, please help me to get the correct formula.

       

      Regards,

      Arihant Jain