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

Find more posts tagged with

Accepted answers

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.