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
Table calc s always very complicate, but focusing on briging your expected value, here is the approach
if this helped, please mark my answer as correct / helped to close the thread, not from inbox but from original post.
Thanks,
Shin
