--- schema_version: "1" id: 062081e7ee95431e89a701a987cf3be16190a2926b328de82f8e80f2b1a7a4cf title: Formula Operators collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_data_mapping_operators.md canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_data_mapping_operators.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: e8e3771bcf47701694496a61b6a3dc641c0269dc856ab7c5ebcb5d8635eabcc5 description: A formula is a mathematical relationship or rule expressed in symbols. With Marketing Cloud Intelligence, you can use formulas to create calculated measurements and dimensions when mapping your data. Operators specify the type of calculation to perform on the terms in a formula—such as addition, subtraction, multiplication, or division. products: - Marketing - Marketing Cloud Intelligence release: "264" --- # Formula Operators A formula is a mathematical relationship or rule expressed in symbols. With Marketing Cloud Intelligence, you can use formulas to create calculated measurements and dimensions when mapping your data. Operators specify the type of calculation to perform on the terms in a formula—such as addition, subtraction, multiplication, or division. There are several types of formula operators available in Marketing Cloud Intelligence, as shown in the following tables:
Comparison Operators
Operator Symbol Operator Name Description Example
== Equal Checks to see if the values on both sides of the operator are equal.

"Foo" == "Foo"

is true

!=

 Not Equal Checks to see if the values on both sides of the operator are not equal.

"foo" != "bar"

is true

>

 Greater Than Checks to see if the value on the left side of the operator is greater than the value on the right.

2 > 1

is true

< Less Than Checks to see if the value on the left of the operator is less than the value on the right side.

1<2

is true

>= Greater Than or Equal to Checks to see if the value on the left side of the operator is greater than or equal to the value on the right side.

1 >= 1

is true

6 >= 5

is true
<= Less Than or Equal to Checks to see if the value on the left side is less than or equal to the value on the right.

2 <= 2

is true

2 <= 3

is true
Contains Value Containment Check Checks to see if the value on the left contains the value on the right. “Foo” var contains "Foo"
Soundslike Soundex Check Performs a Soundex comparison between two strings. Allows you to search by sound key, when you know the pronunciation but not the spelling. "foobar" soundslike "fubar"
Logical Operators | Operator Symbol | Operator Name | Description | Example | | --- | --- | --- | --- | | && | Logical AND | Checks to see that the values on both sides of the operator are true. | foo && bar | | || | Logical OR | Checks to see if either the value on the left or the right is true. | foo || bar | | or | Logical OR | Checks a sequence of values for emptiness and returns the first non-empty value. (This operator, or at least its equivalent functionality, is referred to as the "elves operator" in other languages) | foo or bar or barfoo or 'N/A' | | ~= | Regular Expression Match | Checks to see if the value on the left matches the regular expression on the right. | foo ~= '\[a-z\].+' | Bitwise Operators | Operator Symbol | Operator Name | Description | Example | | --- | --- | --- | --- | | & | Bitwise AND | The & operator compares each binary digit of two integers and returns a new integer, with a 1 wherever both numbers had a 1 and a 0 anywhere else | Foo & 5 | | | | Bitwise OR | The | operator compares each binary digit across two integers and gives back a 1 if either of them is 1. | Foo | 5 | | ^ | Bitwise XOR | When calculating the resulting number, it again compares the binary digits of these numbers. If one or the other is a 1, it inserts a 1 into the result, otherwise, it will insert a 0. | Foo ^ 5 |
Arithmetic Operators
Operator Symbol Operator Name Description Example
+ Addition

Adds the value on the left to the value on the right

Note: When Mapping it must be used in conjunction with the NUMBER() formula, as in the mapping, + is used for concatenation

1 + 2

Returns: 3
- Subtraction. Subtracts the value on the right from the value on the left.

2 - 1

Returns: 1
/ Division Divides the number on the left by the number on the right

2 / 1

Returns: 2
* Multiplication Multiplies the number on the left by the number on the right

2 * 1

Returns: 2
% Modulus Divides the number on the left by the number on the right and returns the remainder.

1 % 2

Returns: 1
Other Operators
Operator Symbol Operator Name Description Example
+ String Concatenation

Concatenation is the process of appending one string to the end of another string

Note: In Calculated Measurements, + is used for addition (see explanation in Arithmetic Operators)

'foo' + 'bar'

Returns: 'foobar'
# Concatenation Operator Concatenates two literals as strings.

1 # 2

returns: '12'
= Assignment Assigns the value on the right to the variable on the left. var = 'foobar'