topic Re: Model Builder 2/- TRA01 Shipping Time in Weeks in Anaplan Platform https://community.anaplan.com/t5/Anaplan-Platform/Model-Builder-2-TRA01-Shipping-Time-in-Weeks/m-p/84455#M18539

Thank you. It worked. 

 

Cheers 

 Sat, 19 Sep 2020 07:26:02 GMT rmat066sysf 2020-09-19T07:26:02Z Model Builder 2/- TRA01 Shipping Time in Weeks https://community.anaplan.com/t5/Anaplan-Platform/Model-Builder-2-TRA01-Shipping-Time-in-Weeks/m-p/84449#M18536

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
 Sat, 19 Sep 2020 05:27:40 GMT https://community.anaplan.com/t5/Anaplan-Platform/Model-Builder-2-TRA01-Shipping-Time-in-Weeks/m-p/84449#M18536 rmat066sysf 2020-09-19T05:27:40Z 再保险:模型构建器2 / - TRA01年代hipping Time in Weeks https://community.anaplan.com/t5/Anaplan-Platform/Model-Builder-2-TRA01-Shipping-Time-in-Weeks/m-p/84454#M18538

Hi , 

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

 Sat, 19 Sep 2020 07:17:48 GMT https://community.anaplan.com/t5/Anaplan-Platform/Model-Builder-2-TRA01-Shipping-Time-in-Weeks/m-p/84454#M18538 JussiLi 2020 - 09 - 19 - t07:17:48z 再保险:模型构建器2 / - TRA01年代hipping Time in Weeks https://community.anaplan.com/t5/Anaplan-Platform/Model-Builder-2-TRA01-Shipping-Time-in-Weeks/m-p/84455#M18539

Thank you. It worked. 

 

Cheers 

 Sat, 19 Sep 2020 07:26:02 GMT https://community.anaplan.com/t5/Anaplan-Platform/Model-Builder-2-TRA01-Shipping-Time-in-Weeks/m-p/84455#M18539 rmat066sysf 2020-09-19T07:26:02Z