I load data for each of our locations that contains sales performance. It is structured like this:
Current Year Sales ("CY TP 13")
Year Ago Sales ("PY TP 13")
From there, I use the following formula to highlight % Change Vs Ya
AVG ([CY TP 13])/avg([PY TP 13])-1
The problem is, I need to create a chart (perhaps a TreeMap), that only displays the data of 'comparable' locations, since some locations that are reporting sales this year weren't open last year, distorting the % change statistic. In other words, I want to calculate locations where PY TP 13>0.
In my example, what would the expression be in the expression editor?
I think this worked, Sunny. I still need to verify the results, but at least the syntax is correct and it is making the calculations and displaying the graph. I just need to validate the results on this end.