Forum Discussion
Helper IGrand Total is not correct
Grand total must be 73,85 but it shows 73,78. Why is it? Can you please help?
11 Replies
- MarcelBeug
Community Champion
The grand total of percentages will be the weighted average.
Example:
6,962 of 10,240 = 67.99%
7,971 of 10,000 = 79,71%
Grand total:
6,962+7,971 = 14,933
10,240 + 10,000 = 20,240
14,933 of 20,240 = 73.78%
aslanIt makes sense. I understood. Well do you have any suggestions do get 73.85 value?
Also how did you find 10,240 and 10,000 values?
- MarcelBeug
Second question first; I started with 6,799/10,000 and 7,971/10,000 and then started muliplying the first 2 values with a factor (trial and error). Factor 1.024 gave the outcome I was looking for.
First question: don't know why you wouldn't want to do that, but anyhow you can calculate the percentages as a calculated column and then include the average values in your report.
