I have a string in my search as below which combines the two fields A and B
Now how to give the condition to display the result to satisfy the below condition.
If A>B, display as A and B
If B>A, display as B and A
you can try something like this:
eval big_and_small = if(A > B, A. "and" .B, B. "and " .A)
This should give you something to start, although I know it will not handle cases where the numbers are equal 😉
Hope this helps ...
View solution in original post