Conditional Functions (Report Builder 1.0)

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.