How to use functions Add(), Subtract(), Multiply() and Divide() to calculate with numbers

About this article

This article explains what the Add(), Subtract(), Multiply() and Divide() functions are that you can use with number values and provide examples of how they can be used with the binding syntax in smart templates.  

• What is the Add() function?
• What is the Subtract() function?
• What is the Multiply() function?
• What is the Divide() function?

Prerequisites

Library and at least one Dynamics module enabled Templafy Desktop and Office VSTO add-in installed on the PC Tenant admin/owner access or Space owner access

 

The functions only support 2 arguments. However you can use more arguments by using nested functions. See example 2 from the Add() function below. Arguments must be numbers (strings that look like numbers are not supported). Arguments can be a literal number (constant) or an expression that resolves as a number-typed value. Positive and negative integer numbers are supported, as well as zero and decimals. Null is treated as zero. This includes treating empty strings as numerical zeros. The decimal separator must be a period, not a comma. The functions are applied to individual numbers only, not to arrays. Dates are not treated as numbers. For dates the date modification functions should be used instead. Division by zero should be avoided. Do not build any logic that depends on division by zero.

 

 

What is the Add() function?

The Add() function returns the sum of two numbers.

 

Add() logic

Syntax	{{Add(Number, Number)}}
Input	Two numbers
Output	The sum of the numbers

 

Example 1

Using the Add() function to calculate the sum of form fields 'Number 1' and 'Number 2'.

Binding	{{Add(Form.Number1, Form.Number2)}}
Input	Form.Number1 = "8" Form.Number2 = "3"	Form.Number1 = "8" Form.Number2 = "-3"	Form.Number1 = "-8" Form.Number2 = "-3"
Output	"11"	"5"	"-11"

 

Example 2

Using the Add() function to calculate the sum of more than two numbers.
Because the Add() function only supports two numbers, you have to use nested Add() functions to calculate the sum of 3 form fields 'Number 1', 'Number 2' and 'Number 3'.

Binding	{{Add(Add(Form.Number1, Form.Number2), Form.Number3)}}
Input	Form.Number1 = "8" Form.Number2 = "3" Form.Number3 = "4"	Form.Number1 = "8" Form.Number2 = "-3" Form.Number3 = "4"	Form.Number1 = "8" Form.Number2 = "0" Form.Number3 = "4"
Output	"15"	"9"	"12"

 

To calculate the sum of 4 form fields 'Number 1', 'Number 2', 'Number 3' and 'Number 4' use this binding.

Binding	{{Add(Add(Form.Number1, Form.Number2), Add(Form.Number3, Form.Number4))}}
Input	Form.Number1 = "8" Form.Number2 = "3" Form.Number3 = "4" Form.Number4 = "7"	Form.Number1 = "8" Form.Number2 = "-3" Form.Number3 = "4" Form.Number4 = "7"	Form.Number1 = "8" Form.Number2 = "0" Form.Number3 = "4" Form.Number4 = "7"
Output	"22"	"16"	"19"

 

Example 3

Using the Add() function to calculate the sum of the fixed value "12" and the form field 'Number 2'.

Binding	{{Add(12, Form.Number2)}}
Input	Form.Number2 = "3"	Form.Number2 = "0"	Form.Number2 = "-3"
Output	"15"	"12"	"9"

 

Example 4

Using the Add() function to calculate the sum of two data source values, with 2 decimals.
This data source is used:

 

The column containing the prices needs to be of Type 'Number'.

 

Binding	$ {{Add(DataSources.Products["Apple"].Price, DataSources.Products["Banana"].Price)}}
Input	Apple = "0.95" Banana = "1.25"
Output	"$ 2.20"

 

 

What is the Subtract() function?

The Subtract() function returns the difference of two numbers.

 

Subtract() logic

Syntax	{{Subtract(Number, Number)}}
Input	Two numbers
Output	The difference of the numbers

 

Example

Using the Subtract() function to calculate the difference of form fields 'Number 1' and 'Number 2'.

Binding	{{Subtract(Form.Number1, Form.Number2)}}
Input	Form.Number1 = "8" Form.Number2 = "3"	Form.Number1 = "3" Form.Number2 = "8"	Form.Number1 = "-3" Form.Number2 = "-8"
Output	"5"	"-5"	"5"

 

 

What is the Multiply() function?

The Multiply() function returns the product of two numbers.

 

Multiply() logic

Syntax	{{Multiply(Number, Number)}}
Input	Two numbers
Output	The product of the numbers

 

Example 1

Using the Multiply() function to calculate the product of form fields 'Number 1' and 'Number 2'.

Binding	{{Multiply(Form.Number1, Form.Number2)}}
Input	Form.Number1 = "8" Form.Number2 = "3"	Form.Number1 = "8" Form.Number2 = "-3"	Form.Number1 = "-8" Form.Number2 = "-3"
Output	"24"	"-24"	"24"

 

Example 2

Combining the Multiply() and Add() functions to calculate the sum of form fields 'Number 1' and 'Number 2' and multiply that value by 5.

Binding	{{Multiply(Add(Form.Number1, Form.Number2), 5)}}
Input	Form.Number1 = "8" Form.Number2 = "3"	Form.Number1 = "8" Form.Number2 = "-3"	Form.Number1 = "-8" Form.Number2 = "-3"
Output	"55"	"25"	"-55"

 

 

What is the Divide() function?

The Divide() function returns the quotient of two numbers.

 

Divide() logic

Syntax	{{Divide(Number, Number)}}
Input	Two numbers
Output	The quotient of the numbers

 

Example 1

Using the Divide() function to calculate the quotient of form fields 'Number 1' and 'Number 2'.

Binding	{{Divide(Form.Number1, Form.Number2)}}
Input	Form.Number1 = "8" Form.Number2 = "3"	Form.Number1 = "8" Form.Number2 = "-3"
Output	"2.6666666666666666666666666667"	"-2.6666666666666666666666666667"

 

Example 2

The same as example 1 but in combination with the FormatNumber() function to set the format so the output shows a maximum of 2 decimals.

Binding	{{FormatNumber(Divide(Form.Number1, Form.Number2), "#.##", "nl-NL")}}
Input	Form.Number1 = "8" Form.Number2 = "3"	Form.Number1 = "8" Form.Number2 = "-3"
Output	"2,67"	"-2,67"

 

Because the language is set to Dutch ("nl-NL"), the decimal separator does not show a period but a comma!

 

 

Related articles

How to use functions GreaterThan(), LessThan() and Equals() with number values How to provide an output based on a condition using IfElse() How to determine if two values are equal using Equals() What is the binding syntax used in smart templates? What are functions, conditions, and operators?