This operator calculation have two type:
- In a CASE statement, AND has precedence over OR.
- If no ELSE expression is specified, the system will automatically add an null.
A Point-and-click generation of case statement logic is given by the Bins tab of the Column Formula
If the last ELSE statement is omitted, “ELSE NULL” is assumed. The case when statement returns then NULL.
CASE WHEN "Sales Facts"."Amount Sold" > 600000 THEN 'Big' WHEN "Sales Facts"."Amount Sold" > 300000 THEN 'Middle' ELSE 'Small' END
Request Condition Operator:
- IN The IN operator can only be used in the repository and not in the logical sql (ie in an answer/analytics)
It's also known as the case Lookup.
'Administrators;XMLP_ADMIN' IN ('Administrators', 'CNT_ADMIN')