How to calculate product price using Alteryx

[hellyars]

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

[hellyars · Accepted solution]

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

[hellyars]

Just decided to do it in Excel