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

seanomahoney

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

Code	CODE(ITEM('G2 Country'))
Region	PARENT(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.

JaredDolich

@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

• Make sure your hierarchy looks like this: