Using Expressions to Perform Data Calculations
Users can use expressions to perform calculations on queried data for data elements and display elements. Different expressions are available for selection depending on the input data for a calculation.
The following expressions are available for any calculation:
To populate a field with a hardcoded value, users must enter the value and select it from the dropdown menu.
Expression 
Description 

Hardcoded string 
Userdefined string 
Hardcoded number 
Userdefined number. Can be a float or an integer. 
Hardcoded date 
Userdefined date as a string 
Hardcoded bool 
Userdefined true or false value 
Field from singleton 
Copies a value from any data element with a single record output 
Count Unique 
Returns the number of unique values in a given list of values 
Sum 
Returns the sum of a given list of numbers 
Product 
Returns the product of a given list of numbers 
Plus 
Returns the sum of two numbers 
Minus 
Returns the difference of two numbers 
Times 
Returns the product of two numbers 
Divide By 
Returns quotient of two numbers 
Round 
Returns a number rounded to the given number of decimal places 
Returns a date string in the given date format. Available date components include:
These date components can be used in any order with any normal separator, including slashes, dashes, spaces, periods, and commas. 

Returns a datetime string in the format of the user’s locale 

Date/Time to Date 
Returns the date from the given datetime value 
Year 
Returns the year number from a given date 
Month 
Returns the month number from a given date 
Day in Month 
Returns the month day number from a given date 
Join Multiple Texts 
Joins a given list of strings into a single string 
Pick a value arbitrarily 
Returns a single value from a given list of values 
Max 
Returns the maximum value from a given list of values 
Min 
Returns the minimum value from a given list of values 
Beginning of Calendar Period 
Calculates the date that is at the beginning of the week/month/quarter/year from a given date 
End of Calendar Period 
Calculates the date that is at the end of the week/month/quarter/year from a given date 
Add to Date 
Calculates a date from a given date plus a selected interval 
Subtract from Date 
Calculates a date from a given date minus a selected interval 
Not 
Returns the opposite true or false value of the given value 
Equals 
Checks if two values are equal. Returns true or false. 
Not Equals 
Checks if two values are note equal. Returns true or false. 
Less Than 
Checks if a value is less than a second value. Returns true or false. 
Less Than or Equals 
Checks if a value is less than or equal to a second value. Returns true or false. 
Greater Than 
Checks if a value is greater than a second value. Returns true or false. 
Greater Than or Equals 
Checks if a value is greater than or equal to a second value. Returns true or false. 
Is Null 
Checks if a value is null. Returns true or false. 
Is Not Null 
Checks if a value is not null. Returns true or false. 
In 
Checks if a list of strings contains the given string. Returns true or false. 
Not In 
Checks if a list of strings does not contain the given string. Returns true or false. 
All 
Checks if all values in a list of values are true 
Any 
Checks if any value in a list of values if true 
Number to Text 
Converts a number value to a string 
If 
Defines a condition evaluating to true or false and the expected output for each result 
Field values from a list of records 
Returns a list of values for a selected field from an existing data element 
List of individual values 
Returns a list of values of the same data type 
The following expressions are only available when performing calculations on a selected list of records:
Expression 
Description 

Local Field 
Returns a value from a field in a given data element 
Related Field 
Returns a list of values satisfying a given condition derived from a list of field values in the selected data element 