TRA01 Shipping Metrics by Week

Options
Aneetabj
Aneetabj Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi 

I wanted to know whether the below mentioned formulas are right for me to move forward with level 2. attaching the screenshot for the same.

shippping time(week) :- YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)')

cost per 1000:-  YEARVALUE('DAT02 Shipping Metrics'.'Cost per 1000 Units')

Tagged:

Comments

  • alethiabwell
    alethiabwell Member, ALL USERS Posts: 1 New Contributor

    Hello @jasonblinn , I am a having a really hard time understanding how using YEARVALUE will convert the years to weeks. From the documentation, I thought YEARVALUE just returns the aggregated values for the year. Therefore, to convert to weeks, I would think you would use YEARVALUE and then divide by 52. That seems like hard coding though. Please explain when you get the chance. Thank you!

Categories