Register

Model Building Level 1 - 6.8.4 Activity: Add Formulas to Country Details Module

seanomahoney
Occasional Contributor

Model Building Level 1 - 6.8.4 Activity: Add Formulas to Country Details Module

I'm attempting the following...In your model, open the SYS03 Country Details System module in Blueprint view.

Add the formulas to the line items: 

 
Line Item Formula
CodeCODE(ITEM('G2 Country'))
RegionPARENT(ITEM('G2 Country'))
Country Only?TRUE

 

When I add the formula, PARENT(ITEM('G2 Country')), to Region line item I receive the below error.

 

Invalid formula:

'SYS03 Country Details'.Region = PARENT(ITEM('G2 Country'))

'SYS03 Country Details'.Region has LIST:G1 Region format but the formula resolves to LIST:G2 Country format

 

Please help.

2 REPLIES 2
JaredDolich
Moderator

Re: Model Building Level 1 - 6.8.4 Activity: Add Formulas to Country Details Module

@seanomahoney 

Looking good so far. here are some suggestions:

  • Make sure you line item for Region is using a format of "list" and is using the "G1 Region" list

LocationHierarchy01.png

  • Make sure your hierarchy looks like this:

LocationHierarchy.png


Jared Dolich
seanomahoney
Occasional Contributor

Re: Model Building Level 1 - 6.8.4 Activity: Add Formulas to Country Details Module

Thank you, Jared! You're my hero!

 

Hierarchy was the issue. 

 

Happy New Year!