7 Replies Latest reply on Sep 10, 2018 7:09 AM by Shinichiro Murakami

    Total not displaying the right value

    stphane.jauffret

      Hello everyone

       

      I am struggling with my total calculation.

      I have computed 3 lines, each of which is in itself a weighted value.

      I want to computed the total of the 3 lines without further calculation

       

      In the tab SUM OF AVERAGE, I have the following set of data, which are weighted averages defined in a calculated field :

      Line 1 -   0,4043

      Line 2 -   0,3149

      Line 3 -  0,0787

      and the total is wrongly set to 0,3333 instead of 0,7979

       

      Anyone has an idea of how I can display the total as being 0,7979 ?

       

      thanks a lot for any help