14 Replies Latest reply: Oct 3, 2016 5:04 PM by Mike Sawyer RSS

    Expression to use for 'Comparable' Locations

    Mike Sawyer

      Good Morning!

       

      I load data for each of our locations that contains sales performance.  It is structured like this:

       

      Unit #     

      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?

       

      Thanks for any help that can be provided?