Page tree
Skip to end of metadata
Go to start of metadata

_format

format() is used to determine the output format of a formula based on the display characteristics of a chosen field. It is most commonly used to set the appropriate display for the output of a formula that includes Currency fields.

Syntax

$formula(format("$table_name.field",$value))

In the syntax above, $table_name.field is the reference to the field whose formatting you want to use.  For instance, $contract.dollar_amount could indicate using the $1.00 standard US currency display format. The formatting field can be referenced from any table. The $value may be any valid formula such as a field or formula including multiple field variables.

Examples

The following example formulas will help you create your own formulas.

FormulaOutput
$formula(format("contract.display_field",$contract_amount)) Inserts the contract amount field formatted with the display characteristics of Display_Field. 
$formula(format("quote.base_currency",$total_amount*$discount_percentage))
Multiplies the Total Amount times the Discount Percentage and formats the output based on the Base Currency field's settings. 
$formula(format("pricing_plan.monthly_price",(($number_of_users*16) + ($number_of_units*5))))Formats this formula using the Monthly Price field in the Pricing Plan table: multiply the number of users times 16 and add five times the number of units.

CONTENTS
  • No labels