Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Evaluates a list of expressions, and returns the value associated with the first condition that returns TRUE. Switch can have one or more condition/value pairs.
Syntax
Switch(condition1, value1, …)
condition1 |
Indicates the condition to test. |
value1 |
Specifies the value or expression that the item should be replaced with, if the condition is True. |
Example
| Formula | Result |
|---|---|
SWITCH(Customer Type = "I", "Individual", Customer Type = "S", "Shop") |
If the Customer Type is "I", the word "Individual" is displayed. If the Customer Type is "S", the word "Shop" is displayed. |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Conditional Functions [(Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Data, Text, and Images (Report Builder)