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.