Conditional Functions [(Report Builder)
Use conditional functions to determine if the values and formulas meet the specified condition. For example, suppose it is the end of the year and you want to determine which employees used all of their vacation, which employees still have vacation hours, and which employees owe the company vacation hours. Using the SWITCH function, you can compare each employee's number of vacation hours to the three conditions specified and replaced with a value depending on the result. Here is another example, suppose you want to identify which clients earned your company's automatic 2% price reduction for paying their last invoice within 30 days of the invoice date. Using the IF function, you could create a condition to return the list of customers who meet these criteria.
Conditional functions can use the following data types: Boolean, DateTime, Integer, Decimal, Float, EntityKey, and String.
In This Section
| Topic | Description |
|---|---|
Returns one value if a condition evaluates to TRUE and another value if a condition evaluates to FALSE. |
|
Determines whether an item is a member of a set. |
|
Evaluates a list of expressions, and returns the value associated with the first condition that returns TRUE. |
See Also
Concepts
Using Functions (Report Builder)
Working with Formulas (Report Builder)
Report Builder How-to Topics