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.
Try sum([2012 Paint Sales]) - sum([2011 Paint Sales])
All the best,