A math challenge. See my follow-up comment below. Basically, how do I solve this using an expression in Alteryx?
I want to calculate the unit cost for two truck types, but....
Truck A (6x6) | Truck B (8x8) | Total Qty All Trucks | Total Cost All Trucks | Composite Avg of Both Truck Types Mixed | 6x6 Cost | 8x8 Cost |
161 | 91 | 252 | 92000000 | 365 | X | Y= X*1.12 |
675 | 325 | 1000 | 382000000 | 382 | ||
339 | 219 | 558 | 240000000 | 430 | ||
292 | 109 | 401 | 154000000 | 154 | ||
150 | 850 | 1000 | 389000000 | 389 |
Gelöst! Gehe zu Lösung.
So,my brain says the following, first example... but how do I translate that o an equation in alteryx?
Let x = 6x6 and y= 8x8
x=0.88y (as x is 12% less than y)
161x + 91y = 92M
161(0.88y) + 91y = 92M
141.68y + 91y = 92M
232.68y = 92M
y= 395,392
161x + 91(395,392) = 92M
x= 347,946
Just decided to do it in Excel