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....
- I know how many of each type (6x6 or 8x8) is being bought. So, I know the ratio of 6x6 to 8x8 trucks.
- I know the total price. So, I can calculate a composite average.
- I also know that the 8x8 should cost 12% more than the 6x6.
- I assume the key is that I know the 8x8 should cost 12% more than the 6x6; I know the ratio of 6x6 to 8x8s, and I know the composite average. But beyond that, my geopolitical background is failing me.
| 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 | | |