Loading

How To Round Off The Number After The First Decimal Place

Date de publication: Mar 10, 2025
Tâche

How to keep one decimal point without rounding?

For example,

If the original value is 89.46, round off to 89.4.
If the original value is 89.74, round off to 89.7.

Étapes

Create a calculation field using the formula below.

Round((OriginalFieldValue-0.05),1)


OR 


  FLOOR(OriginalFieldValue * 10) / 10

This will truncate the number to one decimal place without rounding.

Numéro d’article de la base de connaissances

001453750

Pièces jointes

KeepOneDecimalWithoutRounding.twbx

2431 KB

 
Chargement
Salesforce Help | Article