Posted on:

09 Dec 2020


Sum Vs AGG

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!  
0 answers ( 0 marked as helpful)

Submit an answer