You are reading a single comment by @gbj_tester and its replies.
Click here to read the full conversation.
-
Perhaps percentages confuse the issue? For this calculation we treat as normal numbers.
Example calculation
Sub targets = 70%, 80%, 90%
Total target = 50.4%As 50.4 = (70*80*90)/10000
You've got me wondering if my ratio calculations are wrong.
A+B+C can be anything between 0 and 300.
Thank you for your help!
so for D = 0.81, A = 2.38209453119
I think there's an error in your formula, if you want to put D = 81 then your divisor needs to be 100 not 10000 which would give
A = ∛(0.166875260743 × D)
= 2.38209453119
B = 55.9792214829
C = 60.7434105453
Of course, there is also an error in your formula if you want A+B+C=100 or A+B+C=81