Multiple business 'site' locations. Each has its own working day schedule
Working day schedule added in Prep Flow along w/ calculation of 'Operating Day' where the first working day = 1, second working day = 2
There are multiple transactions per working day per Site
I have figured out how to calculate a monthly daily sales average however what I'm having a problem with is calculating within the same sheet a comparison CY vs PY Avg Daily Sales
ADS = Sum(Sales) / Max(Operating Day)
How do I calculate CY ADS and PY ADS which will allow a YoY ADS calculation taking the difference between them?
Ok so I figured it out. I have a Current Year and Prior Year T/F calculation which is used to create CY Sales and PY Sales. What I needed to do was also create a CY Max Operating Day and PY Max Operating Days calculations. Then the calculation was simply PY Avg Daily Sales = Sum(PY Sales) / Max(Max Operating Day) and the same for CY. From there a YoY calculation is the difference between the CY and PY calculation.
