AnsweredAssumed Answered

Case statement not working?

Question asked by Penny on Sep 14, 2017
Latest reply on Sep 14, 2017 by Penny

Maybe it's Friday but I have a simple Case statement that doesn't seem to be working and I can't see what's gone wrong!

Here is the statement:

Case(EnjoyScale="Good";1; EnjoyScale="Bad";2; EnjoyScale="Indifferent";3)

 

The value is for a field called EnjoyScaleNum to give a number rather than the word selected by the entry in field EnjoyScale. They have option to select Good, Bad or Indifferent.

The Case statement returns a 3 for indifferent but when good or bad are entered, the return is a blank cell.

 

Would be grateful for anyone's help!!

Outcomes