End users with multiple tickets in buckets


  • Dave Dyson
    Hi Greg -
    The CASE statements of the SWITCH function look for exact values -- so when you have "Case 3: (etc.)", that's only going to match if the ticket count is 3 exactly. I think you'll have better luck using an IF/THEN/ELSE structure (e.g. paraphrased: if the ticket count is >=1 and the ticket count is <=10, then "01 -10 Tickets", etc.) instead of SWITCH. See Using the IF THEN ELSE function for more information.

Please sign in to leave a comment.

Powered by Zendesk