--- schema_version: "1" id: 08522d693488ae001fae55a7ef2a375689f3ecefe6a358ad949e7d3fbd7788c3 title: Formula Operators collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mcidp_data_mapping_operators.md canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mcidp_data_mapping_operators.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 194d9dd50f2044fe771a9a12db238197982dd906099ffb8e4e6121c037c9ca8e description: A formula is a mathematical relationship or rule expressed in symbols. With Marketing Cloud Intelligence Data Pipelines, 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 Data Pipelines, 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 MDP, 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'

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'