1 Reply Latest reply on May 6, 2016 2:16 PM by diego.medrano

    Comp Growth calculation

    Fei Sun



      Unfortunately I can not attached the workbook and the data set, so I will use the screenshot to explain my problem.


      The problem is to calculate the "comp growth" for a store:


      "comp growth" is calculated when there is sales data for both current year and last year for a store in all 6 months.


      Take the "AC-ABREEZA MALL" as example, "comp growth" can not be calculated in this case, but if there is data and sales data is not 0 for Apr and May, then we should calculate.


      is there a way to filter out those stores can not be used for calculating "comp growth" and only display and calculated the stores after filtering?


      I have been struggling at this problem for past few days, and still not able to find a way.


      Thank you for the help in advance


      Note:  data does not display because of several reasons: 1.not data in database 2. the sales data is NULL 3. the sales data is 0