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?
TDA-C01 Exam QuestionsBrowse all questions from this exam
TDA-C01 Exam - Question 66
Show AnswerHide Answer
Correct Answer: D
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.
Discussion
4 comments88c0ad8Option: D
May 11, 2024No, 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
ca26d8eOption: A
May 8, 2024Option A
MonBoujOption: D
May 29, 2024By calculating the shown resulat D. (SUM([Sales]) - LOOKUP(SUM([Sales]), -4)) / (LOOKUP(SUM([Sales]), -4))
iccent2Option: D
May 30, 2024D 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.