Model Builder 2/- TRA01 Shipping Time in Weeks
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.
|P2 Products||Ok||P2 Products|
|Ship Methods||Ok||Ship Methods|