FreeMathHelpPlease
New member
- Joined
- Oct 30, 2022
- Messages
- 1
I need help arriving to an average ‘level’ with two values. Amount of sale and level where a 100 level is a sale with no gain or loss.
A 150 level would be a 50% gain.
A 50 level would be a 50% loss.
Example
Sale amount $10,000 - 150 level
Sale amount $1,000 - 50 level
If I average the levels I get 100 but that is not the actual average level across the total sales amount because the 50 level was a $500 loss and the 150 level was a $5,000 gain.
A 150 level would be a 50% gain.
A 50 level would be a 50% loss.
Example
Sale amount $10,000 - 150 level
Sale amount $1,000 - 50 level
If I average the levels I get 100 but that is not the actual average level across the total sales amount because the 50 level was a $500 loss and the 150 level was a $5,000 gain.