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 | |
| DAT02 | Map | TRA01 |
| P2 Products | Ok | P2 Products |
| Ship Methods | Ok | Ship Methods |
| Year | Lookup SYS01 | Week |
0
Best Answer
-
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
2
Comments
-
Thank you. It worked.
Cheers
0
