Advanced function : SUM ? AVG ?

Josselin Granger shared this question 2 months ago
Answered

Hi there,

I often use advanced functions to compute data, and I mainly use those allowing to divide a column by another.

However I'm often stuck with the totals : if I have a column C which show A / B, I want to have at the bottom of my report, under the column C a total which Is SUM(A) / SUM(B).

How can I achieve that ?

Thanks

Comments (2)

photo
1

Hi Josselin,


Thanks for your question.


You should be able to achieve this through Calculated Totals. This will aggregate the totals of both column in question that are referenced in the Calculated Field and output the correct total.


/96833d35099aa71f27ad422f46c16716


Let me know if you have any further questions.


Kind regards,

Simon

photo
2

Hi Josselin,


I'm just messaging to let you know that I am marking this as answered for the moment.


Please feel free to respond here if you have any further questions, and someone will get back to you shortly.


Kind regards,

Simon