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.