Loading

How To Round Off The Number After The First Decimal Place

Дата публикации: Mar 10, 2025
Задача

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.

Действия

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.

Номер статьи базы знаний

001453750

Вложения

KeepOneDecimalWithoutRounding.twbx

2431 KB

 
Загрузка
Salesforce Help | Article