List of ER functions in the logical category
Electronic reporting (ER) logical functions can be used to work with logical values to perform more than one comparison in a single expression or test multiple conditions. This article provides a summary of these functions.
List of supported functions
| Function | Description |
|---|---|
| And | This function returns a Boolean value of TRUE if all the specified conditions are true. Otherwise, it returns a Boolean value of FALSE. |
| Case | This function evaluates the value of the specified expression against the specified alternative options and returns the result of the first option that equals the value of the specified expression. Otherwise, it returns an optional default result, if a default result is specified as the last argument of the called function that isn't preceded by an option. The value that is returned can be a value of any of the supported data types. |
| Contains | This function determines whether the specified input contains the specified text. It returns a Boolean value of TRUE if the specified input contains the specified text. Otherwise, it returns a Boolean value of FALSE. |
| EndsWith | This function determines whether the specified input ends with the specified text. It returns a Boolean value of TRUE if the specified input ends with the specified text. Otherwise, it returns a Boolean value of FALSE. |
| If | This function returns the first specified value if the specified condition is met. Otherwise, it returns the second specified value. The value that is returned can be a value of any of the supported data types. |
| Not | This function returns the reversed logical value of the specified condition as a Boolean value. |
| Or | This function returns a Boolean value of FALSE if all the specified conditions are false. If any specified condition is true, the function returns a Boolean value of TRUE. |
| StartsWith | This function determines whether the specified input starts with the specified text. It returns a Boolean value of TRUE if the specified input starts with the specified text. Otherwise, it returns a Boolean value of FALSE. |
| ValueIn | This function determines whether the specified input matches any value of a specified item in the specified list. It returns a Boolean value of TRUE if the specified input matches the result of running the specified expression for at least one record of the specified list. Otherwise, it returns a Boolean value of FALSE. |
| ValueInLarge | This function determines whether the specified input of the Int64 or Integer type matches any value of a specified item in the specified list. It returns a Boolean value of TRUE if the specified input matches the result of running the specified expression for at least one record of the specified list. Otherwise, it returns a Boolean value of FALSE. |
Additional resources
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for