Level 1 9.2.5 Formula Error

Options
Bhavesh
Bhavesh Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor
in User Experience

Hi,

 

When adding the formulas to the line items for REV05 Price Growth Rates Staging module, I get the following error:


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

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

 
Any help is appreciated. Thanks.
Tagged:

Comments

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

    Thanks @Misbah  Have tried refer & click method but still comes up with the same error

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

    @andre.lie have fixed the issue.

    Turns out that the SYS modules this formula looks up needed to be in a particular format. So once these were pivoted correctly the formula worked.

     

    Thanks to all that have reached out.

Categories