Sum of Highlighted column and total sum is different

Answered
Kapil Dhokai asked on December 20, 2023

Hey,
 
Grand total and Sum of Highlited colum are not matched, 
I am adding JS fiddle and picture of highlited column(In example I have selected 3 columns just to display Grand Total and Sum of Highlited column together. If I select just one column still Sum will be same).
 
Can you please help to understand why not matched

Attachments:
FirstColumnSum.png

3 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster December 20, 2023

Hello, Kapil!
 
Thank you for reaching out to us.
 
Kindly note that for calculating the grand totals in Flexmonster, we use the same aggregation as for the values in each cell. In the described case, this is the distinctcount aggregation.
At the same time, in the auto-calculation bar are always shown the count, sum and average of the chosen cells.
 
Hope it helps.
Feel free to contact us in case of any other questions.
 
Kind regards,
Solomiia

Public
Kapil Dhokai December 20, 2023

Got it.
Thanks Solomiia for explaination.
 
 

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster December 20, 2023

Hello, Kapil!

Thank you for your feedback.

We are happy that our answer was helpful.

Do not hesitate to contact us in case of any other questions.

Kind regards,
Solomiia

Please login or Register to Submit Answer