Same Store Sales Continued - Using Store Open/Close Dates

In a comment on Tuesday's post, Cory asked the following question:

"I want to use the stores start date to determine if it should be included in the same store calculation or not. Y/Y SSS calculation regardless if there are sales for that store this year or last for the specific date range I'm looking at (typically by month for last 13 months). The other twist to my SSS calculation is the store must be open for at least 15 months before it is included in my SSS Total. I hope my question makes sense. Thanks for any guidance you or anyone can offer."

Remember that in my first post, if a store had sales last year, and this year, I included it in the SSS (Same Store Sales) calc.

Read more...