Model Builder 2/- TRA01 Shipping Time in Weeks

[rmat066sysf]

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
DAT02	Map	TRA01
P2 Products	Ok	P2 Products
Ship Methods	Ok	Ship Methods
Year	Lookup SYS01	Week

[JussiLi · Accepted solution]

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

[rmat066sysf]

Thank you. It worked.

Cheers