Hey guys,
in this small workbook example I need also the total percentage compared to the total sales sum.
The real result must be 20,86%, the sales are right.
How I can get the right value?
Do I have to use fixed function?
Thanks for any hints.
2 answers
Good morning
see the attached
I calculated the weighted avg as
it returns this
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
