Highlighted
New Contributor

Level 3 Sprint 1 - Part 4.6.5 Sale Planning Model

"Part 4.6.5 Sale Planning Model says: DAT02 module - In the Sales Planning model, create a DAT02 PY Revenue to CY module to carry forward the FY19 quarterly actual sales revenue to FY20 quarters. For this module, using the LOOKUP function and a Time Settings system module is a more efficient formula than using OFFSET to carry the data forward a year"

 

The historical data is in Data hub and DAT02 is in sales planning model - I am not sure how do I use Lookup function from another model - Is it possible? Your help is highly appreciated.

 

3 REPLIES 3
Highlighted
Regular Contributor

Re: Level 3 Sprint 1 - Part 4.6.5 Sale Planning Model

Hi, @CommunityMember128799 

 

you need to first load data from Data Hub to FY19 in Sales Planning model and then use LOOKUP function to move it forward to FY20.

 

Hope this helps, let me know if you have other questions! 

Highlighted
New Contributor

Re: Level 3 Sprint 1 - Part 4.6.5 Sale Planning Model

Hi Filip, 

 

Many Thanks for your response. Appreciate it. I was able to solve the issue.

 

Regards, 

 

Shaurya 

Highlighted
New Contributor

Re: Level 3 Sprint 1 - Part 4.6.5 Sale Planning Model

Hi @CommunityMember128799 ,

 

Could you give me a hints? - Which are the steps?

 

Thanks

gfra