Is there a ROUNDDOWN function in Salesforce?

No. Salesforce formulas return “Unknown function ROUNDDOWN”. Use TRUNC(number, num_digits) instead, which cuts the number toward zero at the decimal place you choose, like ROUNDDOWN in Excel.

Is the second argument of TRUNC optional in Salesforce?

No. TRUNC(Amount) fails Check Syntax with “Incorrect number of parameters for function TRUNC(). Expected 2, received 1”. Use TRUNC(Amount, 0) to get a whole number.

How do I truncate a number to 2 decimal places in a Salesforce formula?

Use TRUNC(Your_Field__c, 2). For example, 5.678 becomes 5.67. Set the formula field to 2 decimal places as well, so the page shows the same value.

What is the difference between TRUNC and ROUND in Salesforce?

ROUND rounds the last digit it keeps, so ROUND(5.678, 2) returns 5.68. TRUNC just drops the extra digits, so TRUNC(5.678, 2) returns 5.67.

Can TRUNC remove the time from a Date/Time field?

No. TRUNC only accepts numbers. To get the date part of a Date/Time value, use DATEVALUE(Your_DateTime__c).

TRUNC() Function in Salesforce: Syntax and Examples

The TRUNC() function in Salesforce cuts a number down to the number of decimal places you choose, without rounding. A typical case is a sales commission rule: pay 7.5% of the opportunity amount and drop any fraction of a cent instead of rounding it up. ROUND() would sometimes pay an extra cent; TRUNC() follows the rule exactly.

In this tutorial, I will explain the TRUNC() syntax, what each value of the second argument does, how TRUNC differs from ROUND and FLOOR (with results I tested in a Salesforce Developer Edition org), why there is no ROUNDDOWN function, and how to use TRUNC in a formula field step by step.

This Tutorial Covers: