• 1
  • Question
  • Updated 1 year ago
After running the "Stock Out" report on collaboration analytics, I'm curious about the "TY WTD 4WK AVG UNIT SLS" column. What formula is used to achieve this factor? I tried to recreate it on my own and can't come up with the same amount.

Couldn't find a definition anywhere on the website.
Photo of Wendy Helmers

Wendy Helmers

  • 70 Points

Posted 1 year ago

  • 1
Photo of Wilfried

Wilfried, Employee

  • 90 Points 75 badge 2x thumb
Hi Wendy,
"TY WTD 4WK AVG UNIT SLS" represents the average units sold over the last 4 weeks of reporting.

Assuming the last 4 weeks are as follow:
Week 1:6/16/18
Week 2:6/9/18
Week 3:6/2/18
Week 4:5/26/18
TY WTD 4WK AVG UNIT SLS = (Week 1 WTD unit sales+Week 2 WTD unit sales+....+Week 4 WTD unit sales)/4