5 Replies Latest reply on Jul 5, 2012 1:52 PM by P Fro

    Compare values of two fields for each row

    P Fro

      I'm no good at coding...I'm trying to create a calculated field that will output either "Positive" or "Negative" depending on whether a number is greater or less than 0.

       

      In this case, I have a table with a year as the column. There are 6 Measures listed in 6 different rows. I just want to create a field that I can add as a shape to indicate whether the 2011 value is greater or less than 0, like this:

       

      Capture.PNG

      I'm just not good enough with the functions to know how to do that. I tried Lookup, but that seems to require a specific field, where I want to judge each measure separately and I couldn't find any specific examples of this in the message boards.

       

      Thanks for any advice!