The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Sum Vs AGG

Back to all questions

Sum Vs AGG

1 month ago
Vote Up Vote Down
0
Votes
0
Answer

Hi everyone!
I have a question regarding the use of SUM in a calculated field.
 

For the picture above, the GM(gross margin)% is calculated using [Gross Profit]/[Revenue].
Whereas for the picture below, GM% is calculated using SUM([Gross Profit])/SUM([Revenue]).
 

My question is, why did the calculation in the first picture not work (what exactly was it calculating)? AND why do we need to use SUM?
Thank you in advance!
 

No answers so far.
You must to answer this question.
JanuaryPromo
×
Complete Data Science Education
Get 50% OFF