topic L1MB 9.2.5 in Academy & Training https://community.anaplan.com/t5/Academy-Training/L1MB-9-2-5/m-p/97363#M2740 < P >嗨Anaplanners, < /P>

 

I'm getting attached error while using formula to populate my module.

Can someone please help me.

 Wed, 10 Feb 2021 09:33:46 GMT rgarg25 2021-02-10T09:33:46Z L1MB 9.2.5 https://community.anaplan.com/t5/Academy-Training/L1MB-9-2-5/m-p/97363#M2740 < P >嗨Anaplanners, < /P>

 

I'm getting attached error while using formula to populate my module.

Can someone please help me.

 Wed, 10 Feb 2021 09:33:46 GMT https://community.anaplan.com/t5/Academy-Training/L1MB-9-2-5/m-p/97363#M2740 rgarg25 2021-02-10T09:33:46Z Re: L1MB 9.2.5 https://community.anaplan.com/t5/Academy-Training/L1MB-9-2-5/m-p/97364#M2741 The formula looks correct, but I would try pointing to the line items rather than typing, just to be sure the item names are correct. Apologies if you have tried this! Wed, 10 Feb 2021 09:39:34 GMT https://community.anaplan.com/t5/Academy-Training/L1MB-9-2-5/m-p/97364#M2741 MarkWarren 2021-02-10T09:39:34Z Re: L1MB 9.2.5 https://community.anaplan.com/t5/Academy-Training/L1MB-9-2-5/m-p/97365#M2742 I've tried out pointing to the line items as well but still it's giving me an error. Wed, 10 Feb 2021 09:43:29 GMT https://community.anaplan.com/t5/Academy-Training/L1MB-9-2-5/m-p/97365#M2742 rgarg25 2021-02-10T09:43:29Z Re: L1MB 9.2.5 https://community.anaplan.com/t5/Academy-Training/L1MB-9-2-5/m-p/97375#M2743 Could you paste the formula you have?
Here's my version for comparison:

'REV04 Price Growth Rates'.Unit Price %[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product Family] Wed, 10 Feb 2021 10:29:55 GMT https://community.anaplan.com/t5/Academy-Training/L1MB-9-2-5/m-p/97375#M2743 MarkWarren 2021-02-10T10:29:55Z Re: L1MB 9.2.5 https://community.anaplan.com/t5/Academy-Training/L1MB-9-2-5/m-p/97403#M2744

It has been solved. I just pivot the dimensions in SYS04 and SYS06 modules.

Thanks

 Wed, 10 Feb 2021 16:10:48 GMT https://community.anaplan.com/t5/Academy-Training/L1MB-9-2-5/m-p/97403#M2744 rgarg25 2021-02-10T16:10:48Z Re: L1MB 9.2.5 https://community.anaplan.com/t5/Academy-Training/L1MB-9-2-5/m-p/97524#M2751 I should have asked to see the sources first!
Excellent, well done for working through that, good luck with the rest! 星期四,2021年2月11日10:38:38格林尼治时间 https://community.anaplan.com/t5/Academy-Training/L1MB-9-2-5/m-p/97524#M2751 MarkWarren 2021-02-11T10:38:38Z Re: L1MB 9.2.5 https://community.anaplan.com/t5/Academy-Training/L1MB-9-2-5/m-p/132061#M3676

Did you remove time from the SYSO4 module?

 Fri, 11 Feb 2022 17:34:07 GMT https://community.anaplan.com/t5/Academy-Training/L1MB-9-2-5/m-p/132061#M3676 jpazdernik 2022-02-11T17:34:07Z