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

    Amount difference between two dates

    Arihant Jain



      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.



      Arihant Jain