You have the following dataset.
Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?
You have the following dataset.
Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?
The correct formula to calculate the percent difference in sales relative to the same quarter the previous year is (SUM([Sales]) - LOOKUP(SUM([Sales]), -4)) / (LOOKUP(SUM([Sales]), -4)). This formula finds the difference in sales between the current quarter and the same quarter in the previous year using LOOKUP(SUM([Sales]), -4), which looks up the sales figure from four quarters ago. The difference is then divided by the sales from the same quarter in the previous year to give the percent change. The results in the 'Calculation' field in the dataset confirm that this is the correct approach.
No, option A is wrong. You need to calculate the change in dynamic in order to see increase or decrease of sales compared to previous quarter. Therefore there is only formula D can work in this case
D is the correct answer. If anyone is still in doubt, calculate for 2011Q1 using option D: (2011Q1 - 2010Q1)/2010Q1 and check the answer in the calculation column on the table.
By calculating the shown resulat D. (SUM([Sales]) - LOOKUP(SUM([Sales]), -4)) / (LOOKUP(SUM([Sales]), -4))
Option A