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 |