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