Limit number of decimals using SFM Formula function.

Limit number of decimals using SFM Formula function.

We do a number of offline currency calculations using SFM Formulas and need a way to limit values to 2 decimals. This is possible in output documents using the ROUND and LNUMBER functions, but those are not yet available in SFM Formulas.

So, our work order total values sometimes have 3 decimals, even though the service report, and even the Salesforce page layout clearly only show 2 decimals. This sometimes causes discrepancies between the service report and the invoice which the customer receives.

It would be even better to control this at a Global Setting rather than having to configure each functionality separately in order to achieve consistency across the platform. We are currently on Autumn '17.

decimal​ decimal representation​ sfm formulas​ calculations​ offline​ Anita D'SouzaLisa MercerBrittany Taylor​ autumn 17​

Linking to similar 'Decimal' ideas:

What is the underlying problem do you intend to solve with this idea?
Ensure that work order total values are consistently displayed and calculated throughout the ServiceMax Platform and into our SAP ERP.
How is the problem being addressed today, if at all?
We are using the Round function in our output documents. Also we have limited the displayed values within Salesforce by making our custom field with only 2 decimal places.
Product Area?
Communities Work Order Management
What version of ServiceMax are you on?
Summer 17

@mmajerus6   Is this still happening in your current version?


@shivaranjini_g   What is the current status of this Idea?  Thanks!

Product Team
Product Team

@mmajerus6 Introducing new functions in formula designer is not is on the immediate roadmap. We will revisit this idea post GA of new designer.

Pastry Chef mmajerus6
Pastry Chef

Hello @shivaranjini_g. When is the GA of the new designer scheduled for?

Product Team
Product Team

@mmajerus6  New designer will be GA'ed in 19.3. Schedule yet to finalized, most probably end of the year. Upcoming 19.2 will be a beta release.

CC @anita_dsouza