numbervalue

Converts a text string or currency value into an integer or decimal in Salesforce Spiff.

Required Editions

Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience
Available in: Enterprise, Unlimited, and Developer Editions
Available for an additional cost in: Professional Edition with Web Services API Enabled

Syntax

numbervalue(value)

Arguments

Argument Required? Description
value Required The text string or currency value to convert. You can also specify the name of a field with these data types, such as ARR__c, which is a Currency data type.

Example

Convert $100 in currency to a decimal, which returns 100.

=numbervalue($100.00)

Convert the currency value of the ARR__c field.

=numbervalue(ARR__c)