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

    Calculated Field Using Other Calculated Fields

    Greg James



      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




      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.