Multi-Row Formula to multiply one column value against fixed value.

wjohns50

Hi All,

I'm relatively new to Alteryx, so maybe this is simple, but I've been beating my head against the wall for 4 hours, so I'm calling for help.

I'm trying to create a Multi-Row Formula to multiply the values in column x against the value in Row 2 of column y. Multiplying column x against a specific value in a table would also work. Below is the example with results manually entered for device 1:

Data	# of Component 1	Component 1 Cost	# of Component 2	Component 2 Cost
Device 1	2	$200	2	$40
Device 2	5		1
Device 3	3		7
Device 4	4		1
Device 5	5		10
Device 6	9		6
Device 7	2		8
Device 8	1		1

Rate Table	Cost
Component 1 Cost/unit	$100
Component 2 Cost/unit	$20

I have 16 different component columns to assemble unique cost formulas that will be applied to 20,000+ rows, but most revolve around multiplying value x against value y, so this will be a good start in troubleshooting the others. Any help would be much appreciated!

TomWelgemoed

Hi @wjohns50 ,

I think you can get away with just an append here after you've calculated the cost of each item. I hope I've understood you're issue correctly, but I would simply calculate the cost per item, take that cost and it append it back to the data set for it to apply to each line. 

I attach the workflow as well. The only caveat is if you had more prices and only wanted to attach that to specific rows etc...then you may want to start looking at either a join or indeed a multi-row formula.

Hope this helps,

Tom

Append example.yxzp