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 |
Solved! Go to Solution.
Hi @TTYYQQ
Here's a slightly shorter way of achieving this using an append tool rather than the join that @RishiK 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.
Awesome! Thank you so much!
Great! Thanks!