Caly
Board Regular
- Joined
- Jul 19, 2015
- Messages
- 161
- Office Version
- 365
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hi I have data sales last week compared to this week with some being negative but is this the correct representation to show the change compared to last week? The negative numbers are confusing me.
I have year over year data so This Year versus Last Year from both this week (current) and last week (prior).
From that I calculate the change in dollars $ and percents % for this week current and also last week prior.
For one set of data the change is negative. The dollars change ($4,496,394.08) this week and the percent is -12.88%.
Last week the change dollars was ($4,457,938.68) and the percent was -12.94%
Based on the change values from current and prior I’m doing the change in dollars and percents and coming up with the below:
Change($): ($38,455.40)
Change (%): 0.86%
But the change current is higher than prior with it being ($4,496,394.08) and prior was ($4,457,938.68) so why is the margin percent change showing a positive when the dollar change is a negative?
I’m trying to show the difference to say UP or DOWN when comparing the values by writing the formula as below:
=If(the percent change =0,”same”,if(the percent value >0,”UP”,”DOWN”))
The answer in the values above is coming up as UP since the percent change shows positive but is it? Shouldn’t it be DOWN because if I change the formula to
Look at the change age in dollars instead it will say DOWN
Example of the values:
Current week year over year
Last year: $34,910,092.98
This year: $30,413,698.89
Change ($): ($4,496,394.08) formula: =this year minus last year
Change (%): -12.88% formula: =(this year minus last year)/last year
Prior week year over year
Last year: $34,454,142.99
This year: $29,996,204.30
Change ($): ($4,457,938.68)
Change (%): -12.94%
Change based on comparing current to prior week looking at the Change ($) and Change (%):
($): ($38,455.40) formula: =the change $ from current week minus the change $ from prior week which is =($4,496,394.08) - ($4,457,938.68)
(%): 0.86% formula: =($4,496,394.08) - ($4,457,938.68)/($4,457,938.68)
Up or down: answer shows UP because -12.94% from prior week is less than the current week of -12.88% although still a negative But the dollar value is lower so should it be DOWN instead since the prior week change was ($4,457,938.68) and the current week change is ($4,496,394.08)
I have year over year data so This Year versus Last Year from both this week (current) and last week (prior).
From that I calculate the change in dollars $ and percents % for this week current and also last week prior.
For one set of data the change is negative. The dollars change ($4,496,394.08) this week and the percent is -12.88%.
Last week the change dollars was ($4,457,938.68) and the percent was -12.94%
Based on the change values from current and prior I’m doing the change in dollars and percents and coming up with the below:
Change($): ($38,455.40)
Change (%): 0.86%
But the change current is higher than prior with it being ($4,496,394.08) and prior was ($4,457,938.68) so why is the margin percent change showing a positive when the dollar change is a negative?
I’m trying to show the difference to say UP or DOWN when comparing the values by writing the formula as below:
=If(the percent change =0,”same”,if(the percent value >0,”UP”,”DOWN”))
The answer in the values above is coming up as UP since the percent change shows positive but is it? Shouldn’t it be DOWN because if I change the formula to
Look at the change age in dollars instead it will say DOWN
Example of the values:
Current week year over year
Last year: $34,910,092.98
This year: $30,413,698.89
Change ($): ($4,496,394.08) formula: =this year minus last year
Change (%): -12.88% formula: =(this year minus last year)/last year
Prior week year over year
Last year: $34,454,142.99
This year: $29,996,204.30
Change ($): ($4,457,938.68)
Change (%): -12.94%
Change based on comparing current to prior week looking at the Change ($) and Change (%):
($): ($38,455.40) formula: =the change $ from current week minus the change $ from prior week which is =($4,496,394.08) - ($4,457,938.68)
(%): 0.86% formula: =($4,496,394.08) - ($4,457,938.68)/($4,457,938.68)
Up or down: answer shows UP because -12.94% from prior week is less than the current week of -12.88% although still a negative But the dollar value is lower so should it be DOWN instead since the prior week change was ($4,457,938.68) and the current week change is ($4,496,394.08)