You can use the STR() function to convert the parameter value to a string:
If ([patient age]>[PARAMETER AGE])
then "Greater Than " + STR([PARAMETER AGE])
else "Less Than " + STR([PARAMETER AGE])
You could also calculate the difference and then use custom formatting of the field to give you different formats for positive versus negative values. If performance becomes an issue, come back to this thought. Otherwise, the above code is likely more straightforward.
Hope this helps!
Fantastic! Thanks. This is what I needed. Renelle
You're welcome! Happy to help!
Please find the below code.May be it's helpful to you.
then "LessThan " + STR([PARAMETER ])
else "GreaterThan "+ STR([PARAMETER])
Sreenadha Reddy Palakolanu