
1. Re: Total Subtraction Calculation
Jenny Sanders Sep 22, 2016 2:34 PM (in response to Tiffany Kinson)Hi Tiffany,
Trying doing a quick Table calculation. Right click on Sum(Final Forecast) >Quick Table calculation > Difference. It should give the difference from the previous value.
Let me know if this works. Can you please post a sample workbook?
Thanks !

2. Re: Total Subtraction Calculation
Tiffany Kinson Sep 22, 2016 2:44 PM (in response to Jenny Sanders)Hi Jenny,
When I try the table calculation, it doesn’t give me a column to the right of the September column. Do you know what I should have for the calculate the difference and display attributes?
If I do Table down and previous, it applies the calculation with the current columns.

image001.png 20.3 KB


3. Re: Total Subtraction Calculation
Alex Xu Sep 22, 2016 2:49 PM (in response to Tiffany Kinson)i will create 3 calculated field
c1:
IF DATENAME("month",[Period of]) = "August" and DATEPART("year",[Period of]) = 2016
THEN SUM([Final Forecast])
END
c2.
IF DATENAME("month",[Period of]) = "September" and DATEPART("year",[Period of]) = 2016
THEN SUM([Final Forecast])
END
c3:
c1  c2
then put these three calculation field as measure values: sth like this

4. Re: Total Subtraction Calculation
Surendra Sharma Sep 22, 2016 11:21 PM (in response to Tiffany Kinson)1 of 1 people found this helpful