Implementing a simple formula

[ggarciav (Gonzalo)]

On the column: Input est. ERC Amount, the amount is $20,000 so on the column Your Estimated Commission should display $300 which is a commission of 1.5% . I have used this two formulas but won’t work:

{Input est. ERC Amount} * (1.5 / 100)

MULTIPLY(0.15,{Input est. ERC Amount})

Please let me know what is the correct formula.

[RaymondChin]

You were VERY close! in fact, your first formula should have worked, so I’m not sure what the error was there. With your second formula, you accidentally multiplied by 15% instead of 1.5%.

What are your column types?