// Example 1: Orders table — PaymentReceived and ItemsShipped are the two conditions, IsExempt is the exempt flag Compliance Status = SWITCH( TRUE(), // Exempt: row is marked as excluded from compliance checks Orders[IsExempt] = TRUE(), "Exempt", // Compliant: payment received AND items shipped Orders[PaymentReceived] = TRUE() && Orders[ItemsShipped] = TRUE(), "Compliant", // Partial: one condition met but not both Orders[PaymentReceived] = TRUE() || Orders[ItemsShipped] = TRUE(), "Partial", // Non-Compliant: neither condition met "Non-Compliant" ) // Self-check: possible output values are Compliant, Partial, Non-Compliant, Exempt