AnsweredAssumed Answered

Using the case function

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

Title

Using the case function

Post

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...

Outcomes