This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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:
Percent I've turned to a decimal, so 40% = 0.4
Then it's simply Amount x Percent = Ownership x Amount.