I'm looking to display text dependent on the value of a calculated field. For example if a calculated field is below 0 I want some text to be displayed and if the field is over 0 I want some different text to be displayed. I have viewed the other support tickets and I know that you can't use text in a calculated equation.
Is there any other way?
Thanks for your help.