Last answered:

28 Oct 2021

Posted on:

20 Oct 2021

1

Introduction to Tableau Exam Question 3 Confusion

Hey guys,
I'm confused with the answer for Question 3 where it says
Gross Profit = Revenue - COGS

Having chosen the answer SUM([Revenue]) - SUM([COGS]), it is apparently wrong? And the answer is instead SUM([Revenue]) + SUM([COGS]).
I'm not fully understanding why it's a plus instead of the minus as the equation suggests?
image.png

2 answers ( 0 marked as helpful)
Posted on:

28 Oct 2021

1

Hi Gian. I also did this. I was trying to figure this out late at night. That was my problem:) If you look at the  COGS in the Data Source tab, you see that the COGS values have negative signs in front of them, that is why they have to be added in order to "subtract" them. If you were struggling with number 4, this issue should fix that as well. Good luck!

Posted on:

28 Oct 2021

1

Ah yes, that makes sense. Thanks a lot for the reply Kili :))

Submit an answer