Level 3 Sprint 1 - Part 4.6.5 Sale Planning Model

Options
CommunityMember128799
CommunityMember128799 Member, ALL USERS, GroupMember, Partner, Community Member, Certified Model Builder Posts: 4 Occasional Contributor
in Anaplan Community

"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.

 

Tagged:

Comments

  • CommunityMember128799
    CommunityMember128799 Member, ALL USERS, GroupMember, Partner, Community Member, Certified Model Builder Posts: 4 Occasional Contributor

    Hi Filip, 

     

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

     

    Regards, 

     

    Shaurya 

  • gfraotero
    gfraotero Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

    Hi @CommunityMember128799 ,

     

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

     

    Thanks

    gfra

  • vipsgoyani2000
    vipsgoyani2000 Member, ALL USERS, Community Member, Certified Model Builder Posts: 3 Occasional Contributor
    @BahalR looking up in line item for Time Settings module would help !

Categories