1 Reply Latest reply on Jan 17, 2013 3:30 AM by Darren Evans

    Calculated Field Using Other Calculated Fields

    Greg James

      Hi,

       

      I'm a new user and I'm trying to create a calculated field using other calculated fields -- and I'm getting stuck.  The first set of calculated fields work great, but the calculated field that uses the other calculated fields isn't working and I don't know what I'm doing wrong.

       

      I have a date field called "Month" and attribute called "Sales" that contains sales values by month for several categories.  I'm trying to create two calculated fields -- one for sales in 2011, and the other for sales in 2012.  For example:

       

      IF (YEAR([Month]) = 2011) THEN

        [Sales]

      END

       

      From there, I want to create a calculated field to determine the difference between 2011 and 2012.  For example:

       

      [2012 Paint Sales] - [2011 Paint Sales]

       

      This field isn't showing any values.  Would appreciate any assistance.

       

      Thanks for your help.