AnsweredAssumed Answered

Using the case function

Question asked by Infoexcel on Nov 4, 2009
Latest reply on Nov 5, 2009 by raybaudi


Using the case function


Hi, I am using the case function in a field and want the data from another field (as this can be variable) to be part of the result...Is this possible?


I have tried the following:


I.e. Case ( x= "y" ; "text & <<other field data>>"; x ≠ "y" ; "")


But the result simply brings back "text & <<other field data>>"


Thanks in advance...