9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module

Options
FarisFarhan
FarisFarhan Member, ALL USERS Posts: 5 Occasional Contributor
in Anaplan Community

I am trying to add the below formula to the line item (Unit Price %) in the REV05 Price Growth Rates Staging module and I keep getting the an error message 

 

'REV04 Price Growth Rates'.Unit Price%[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product Family]

 

The error message I am receiving is below. May somebody please help advise what I am doing wrong? 

 

The formula for 'REV05 Price Growth Rates Staging'.Unit Price % is invalid:

'REV05 Price Growth Rates Staging'.Unit Price % = 'REV04 Price Growth Rates'.Unit Price %[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product Family] 

Tagged:

Comments

  • FarisFarhan
    FarisFarhan Member, ALL USERS Posts: 5 Occasional Contributor

    Hi Jared, 

     

    First & foremost thank you for responding to my thread! Please see screenshots of module. Maybe this will help you, help me! 

         

    REV05 Price Growth Rates Module.PNG

    SYS04 Location Details Module.PNG

    SYS06 Product Details Module.PNG

    Formula I am getting error message on.PNG

    REV04 price Growth Rates Module.PNG

  • FarisFarhan
    FarisFarhan Member, ALL USERS Posts: 5 Occasional Contributor

    Jared I have added the space and still seem to be getting an error message 😞 

     

    I don't know what I could possibly be doing wrong. I have been trying to work this error message for 2 weeks now!

     

    FarisFarhan_0-1612985171780.png

     

  • FarisFarhan
    FarisFarhan Member, ALL USERS Posts: 5 Occasional Contributor

    @JaredDolich 

     

    I have attempted to add the formula by clicking on the line items as opposed to copying and pasting & I am getting the same error message.

     

    However, I did notice something on my Model that was a little different then the model in 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module.

     

    In my SYS06 Product Details module, the product family shows as "CH" and in the Lesson 9.25 module is shows as "Chocolate". Could this possibly be the reason for my error message? If so may you please advise how I can fix my module to match the Lesson 9.25. I attempted to do this on my own by going back to the earlier lessons but could not figure it out. 

     

    Please see screenshots for your reference & thank you in advanced! 

     

    FarisFarhan_0-1613490802568.png

     

    FarisFarhan_1-1613490836799.png

     

  • FarisFarhan
    FarisFarhan Member, ALL USERS Posts: 5 Occasional Contributor

    @JaredDolich 

     

    I have finally got this formula to work! I had once of my collogues assist me, I had time as a dimension in my SYS04 Location Details Module. 

     

    Once I removed time as a dimension the formula worked!

     

     Thank you very much for your help Jared! 

  • dorfano
    dorfano Member, ALL USERS, Partner Posts: 1 New Contributor
    I had the same problem, it helped me a lot. Thanks for sharing!
  • Shubhamjuyal
    Shubhamjuyal Member, ALL USERS Posts: 1 New Contributor

    Hi, 

     

    Can anyone tell me how to add 5% in the unit cost %

     

Categories