Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
59
Views
Topic starter
Dear Myndra,
My confusion is why the formula of the average selling price/unit doesn't match with each field calculation.
I increase one column for selling price/ unit( Sales divide by no. of weight) but at the end of the bottom , the total average price ,not equal to correct calculation.
Could you provide me an answer?
Thanks,
C. Pakamon
Posted : 27/12/2019 4:19 am
Hi Pakamon,
Sure, can you please upload your sample Excel file so I can see how you're calculating the average.
Mynda
Posted : 27/12/2019 7:33 pm
