4 Replies Latest reply on Sep 22, 2016 11:21 PM by Surendra Sharma

# Total Subtraction Calculation

Hello,

I am trying to do a simple calculation in my worksheet.

I want to show the difference between August and September. I would like a "Quantity Change" to the right of the September column. So for example, the first item I would like the calculation to show 3-10 = -7 for the month of October.

• ###### 1. Re: Total Subtraction Calculation

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

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.

• ###### 3. Re: Total Subtraction Calculation

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

Hi Tiffany,

Maybe this calculated field will help.

Cheers.

1 of 1 people found this helpful