3 Replies Latest reply on Jul 27, 2015 2:04 PM by 2973433

    "Unresolved identifier" when using WHEN CASE function

    2973433

      Hi,

       

      I want to create following measure:

      CASE WHEN  "MODEL"."Customer"."name"=Mark  THEN 1 ELSE 0 END

       

      but I get error:

      Unable to create Expression

      CASE WHEN  "MODEL"."Customer"."name"=Mark  THEN 1 ELSE 0 END

      due to following error(s):

      [nQSError: 27009] Unresolved identifier: "Mark".

       

      It seems like I can only put numbers as value (ie "1" instead of "Mark") and then it works. Why cant I put any text values?