I am trying to use a calculation field to look at another calculation field and do the following:
- IF the first calculation field's number is a positive #, then display the text "Positive"
- IF the first calculation field's number is a negative #, then display the text "Negative"
Seems simple enough. I have tried an number of things though with no success. Any help would be most appreciated.
Thank you! - Scott
Please sign in to leave a comment.