I am having an issue with one of my gauges--if two years are not selected when trying to compare previous years, the expression returns null. It works fine comparing the current and previous year (2012 vs 2011). While the expession works if you select both of the years you want to compare, this is not ideal.
An additional note: the other gauges on this sheet work fine when comparing previous years; however, none of the other gauges are using Avg(Aggr(
Thank you for taking the time to try to address my problem. Unfortunately, your example still experiences the same issue I am having in my object--when trying to compare anything but the current and previous, you must select both of the years you want to compare. If you only select one year, the gauge does not work.
I was hoping to find something that would compare the max year (based on the current selection) to the previous year. So say if you select 2011, then in the gauge it would compare 2011 to 2010.
While my original question was solved, I am experiencing another small issue--When trying to use this same formula, but only looking at Fridays, it is giving me the same problem--both years need to be selected in order for it to work.