Decimal Point formula help

david hennessy

Hi All,

Please can you help me with this simple formula

the formula in 'Net Revenue'

=[Sell (LOCAL CURRENCY)]@row - [Cost (LOCAL CURRENCY)]@row

'Rev %'

=[Net Revenue (LOCAL CURRENCY)]@row / [Cost (LOCAL CURRENCY)]@row

but it does not like the decimal places which we need for accurate numbers

Thanks for help in advance

Ramzi K

It appears that it sees your cell values as text and not numbers. Try highlighting your Cost and Cell columns and converting to number format using this menu bar command:

I hope this helps.

Ramzi

david hennessy

Hi Ramzi,

Tried this.. the column is set to text/numbers, also added the command and no change

David Joyeuse

Hi @david hennessy

From your screenshot, it's clear Cost and Sell are strings for Smartsheet, on the second line. Are those numbers directly typed in or do they come from a formula, which may be the first problem.

Still, you can correct both of your formulas using the VALUE function:

in 'Net Revenue'

=VALUE([Sell (LOCAL CURRENCY)]@row) - VALUE([Cost (LOCAL CURRENCY)]@row)

'Rev %'

=VALUE([Net Revenue (LOCAL CURRENCY)]@row) / VALUE([Cost (LOCAL CURRENCY)]@row)

Hope it helped!