power()

The power() function provides the ability to use exponents in expressions.

Syntax

power(base, exponent)

Argument Description
base

(required)

The base number. An expression that results in a numeric value (i.e., a hard-coded number, a reference to a numeric attribute, or an expression that returns a numeric value).
exponent

(required)

The exponent to which the base number is raised. An expression that results in a numeric value (i.e., a hard-coded number, a reference to a numeric attribute, or an expression that returns a numeric value).

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

power(Base__c, Exponent__c)

((power((1+ROI__c),(1/Years__c)))-1)*100

Principal_Amount__c * Interest__c/Interval__c*power((1+Interest__c/Interval__c),(Payments__c*12))/(power((1+Interest__c/Interval__c),(Payments__c*12))-1)

Field Editability expression

Tab Visibility expression

Business rules: Condition

Target_Annualized_ROI_Rate__c > (power((1+ROI__c),(1/Years__c)))-1
Business rules: Notification Subject

Business rules: Notification Body

Dynamic Filter

{!power(Base__c, Exponent__c)}
Metric expression power(sumif(Initiative__t, OPEX__m.actual__d.timePeriod("2023-01-01")), 0.5)

 

Updated on January 29, 2024

Related Articles