round()

The round() function rounds a number to a specified number of digits.

Syntax

round(value, precision)

Argument Description
value

(required)

 

An expression that results in a numeric value (i.e., a hard-coded number, a reference to a numeric attribute, or a function that returns a numeric value).
precision

(required)

The number of digits to which the value will be rounded.

Where Available

Available in all places the injected expression icon is visible, as well as within Filter fields on Cards, Tables and List/View sections.

Examples

Where Example(s)
Business rules: Set Value

Attribute expression

round(FTE__c, 2)

round(days(dueDate, startDate) / FTE__c, 4)

if(Num1__c>100000000, round(Num1__c/1000000, 0) & "M", if(Num1__c>10000000, round(Num1__c/1000000, 1) & "M", if(Num1__c>1000000, round(Num1__c/1000000, 2) & "M", if(Num1__c>100000, round(Num1__c/1000, 0)&"K", if(Num1__c>10000, round(Num1__c/1000, 1) & "K", Num1__c)))))

Field Editability expression

Tab Visibility expression

Business rules: Condition

round(Num1__c,2) < round(Num2__c,2)

round(if(Business_Unit__c="East",Num1__c,Num2__c), 2) > 15

Business rules: Notification Subject

Business rules: Notification Body

Dynamic Filter

{!round(Hours_Worked__c,1)}

 

 

Embedded Section URL attribute

Business Rule: URL Call

External View URL on List/View

{!if(round (Employee_Average_Salary__m.actual__d.timePeriod(Day_Zero__c), 0)>100, URL1__c, URL2__c)}
Metric expression round(averageif(Initiative__t, OPEX__m),2)

round(sumif(Initiative__t, OPEX__m, active and Red_Team_Review__c < addDays(startDate, 10)),2)

 

Updated on January 29, 2024

Related Articles