Exam TDA-C01 All QuestionsBrowse all questions from this exam
Question 66

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?

    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
88c0ad8Option: D

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

iccent2Option: D

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.

MonBoujOption: D

By calculating the shown resulat D. (SUM([Sales]) - LOOKUP(SUM([Sales]), -4)) / (LOOKUP(SUM([Sales]), -4))

ca26d8eOption: A

Option A