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?
2 answers ( 0 marked as helpful)
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!
Ah yes, that makes sense. Thanks a lot for the reply Kili :))