2 Replies Latest reply on Jan 13, 2019 11:08 PM by Sander Binda

    Calculation behind the 'automatic' grand total

    Sander Binda

      So could anyone explain to me the calculation behind the 'automatic' 'total using' because it does not make sense to me.

      The attachment shows absolute values and a percentage.

      Currently the grand total of the percentage shows 74% which is calculated using 'automatic'.

      But when calculated the average of all the percentages it gets to 72%.

      Even worse, when I calculate the weighted average of the percentage (absolute number*percentage and then divide the total of that by the total of the absolute number) I get to 77%.