Calculate percentage of Deal Value

I am trying to create a column that will show a percentage of the deal value column and running into trouble. I thought it would be {Deal value}*(.45) but it seems that the formula does not like me to put a decimal there. Any thoughts? It multiplies by whatever number I use without a decimal just fine. I also need the formula to be formatted as a dollar amount.

I think I got it:

(({Deal Value})*-{Numbers})+{Deal Value} where Numbers is a discount percent column.

Only trouble is that it is not formated as a dollar amount.

Hey @dstarr! If you click into the formula summary you should be able to choose/customise the value units:

Hope this helps!

That works thank you.