Model Builder 2/- TRA01 Shipping Time in Weeks

rmat066sysf
Occasional Contributor

Model Builder 2/- TRA01 Shipping Time in Weeks

Hi

Been trying to figure out this formula but unable to due to the Year to week Lookup criteria . Any suggestions pls  

The formula for 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)' is invalid:

'Shipping Time (Weeks)' = YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)' [LOOKUP: 'SYS01 Time Settings By Week'.Current Period?]
 
 
Thanks in advance for your help and guidance.
 

Lookup Ref:

Source Target
DAT02MapTRA01
P2 ProductsOkP2 Products
Ship MethodsOkShip Methods
YearLookup SYS01Week
1 ACCEPTED SOLUTION

Accepted Solutions
JussiLi
Frequent Contributor

Re: Model Builder 2/- TRA01 Shipping Time in Weeks

Hi @rmat066sysf

YEARVALUE function is automatically retrieving year value from the source. It doesn't require (or even allow) LOOKUP function to be used with it. 

 

Regards,

JussiLi

View solution in original post

2 REPLIES 2
JussiLi
Frequent Contributor

Re: Model Builder 2/- TRA01 Shipping Time in Weeks

Hi @rmat066sysf

YEARVALUE function is automatically retrieving year value from the source. It doesn't require (or even allow) LOOKUP function to be used with it. 

 

Regards,

JussiLi

View solution in original post

rmat066sysf
Occasional Contributor

Re: Model Builder 2/- TRA01 Shipping Time in Weeks

Thank you. It worked. 

 

Cheers