1 2 Previous Next 16 Replies Latest reply on Sep 13, 2018 8:21 PM by Anisha Jhamb

    Expected type string, found integer.  Comparison in 'CASE' expression must be string type.

    Manuel Ramos

      Can someone help me fix this Calculated Field?

       

      CASE [Case Distributions, Backlog & Closures Picker]

      WHEN 1 THEN [Assigned to CSR GMT] >= DATE([DATEADD('hour',7,NOW())])

      WHEN 2 THEN DATE([Assigned to CSR GMT]) = DATE([DATEADD('hour',7,NOW())])-1

      WHEN 3 THEN STR([CLOSEDDATE_GMT]) = NULL

      END

       

      The error message states, that the comparison in 'CASE' expression must be string type however, I've seen calculations like the one below work.

       

      CASE [Sum of Profit or Sum of Sales Picker]

      WHEN 1 THEN SUM([Profit])

      WHEN 2 THEN SUM([Sales])

      END

       

      Can you someone help me understand how to fix my calculation?

        1 2 Previous Next