Multipling Two Tables

[TTYYQQ]

Dear Colleagues,

Thanks for your help!  I was trying to multiply two tables but cannot figure it out. I did search the community but cannot find an applicable solution. Say we have table 1 and table 2 as below. And we would like to output table 3.

Table 1:

Partner	Ownership %
A	40%
B	60%

Table 2:

Category	Amount
Cash	10,000
Inventory	25,000
Debt	-15,000

Table 3:

Partner	Category	Ownership X Amount
A	Cash	4,000
A	Inventory	10,000
A	Debt	-6,000
B	Cash	6,000
B	Inventory	15,000
B	Debt	-9,000

[rkapoor · Accepted solution]

@TTYYQQ 

Take a look at the attached sample workflow.

[tonypreece · Accepted solution]

Hi @TTYYQQ 

Here's a slightly shorter way of achieving this using an append tool rather than the join that @rkapoor provided. This assumes your Amount field doesn't contain a comma and your percentage field does contain the '%' symbol, which I've removed in the formula tool.

If your amount is stored as a string with a comma present, add the following formula to remove it, assuming amounts are all tens of thousands:

tonumber(substring([Amount],0,2))*100

Percent I've turned to a decimal, so 40% = 0.4

Then it's simply Amount x Percent = Ownership x Amount.

[TTYYQQ]

Awesome!  Thank you so much! 

[TTYYQQ]

Great!  Thanks!