• 1
  • Question
  • Updated 11 months 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 11 months 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