Change in Sales

[tracycrown]

Dear Sir/Madam

Kindly advise how to set a formula in script to compute change in sales.

Thank you

Tracy

[tresesco]

Try using TOTAL in formula like:

=sum(Sales)-Above(TOTAL sum(Sales))

[tracycrown]

Dear Tresesco

Thank you for your quick response.

What if there are more than one plan per attached, above(total sum()) is not correct. Please advise

Thank you

Tracy

[tracycrown]

Dear all,

Can someone help me on this, the correct answer should be as follow :

Plan	Start	End	Sales	Change in Sales
1	01-11-19	30-11-19	$5,000
1	01-12-19	31-12-19	$25,000	$20,000
2	01-01-20	29-02-20	$75,000
2	01-03-20	31-12-20	$285,000	$210,000

Thank you, Tracy

[tresesco · Accepted solution]

Try this:

=Sum(Sales)- If(Above(TOTAL Plan)=Plan, Above(TOTAL Sum(Sales)), Sum(Sales))