Level 1 Model Building Part 7 - Adding formulas to line items after importing

krissymccann

I am trying to add the formula (CODE(ITEM('G1 REGION')) to the SYS02 Region Details. I keep getting an error message that the formula is invalid because code does not apply to any of the lists (it has an empty applies to). I have a feeling that my applies to box should be filled with G1 region, but I am afraid that putting that in and being wrong may cause irreversible damage. Does anyone know how to solve this issue?

filip.sypniewski

Hi @krissymccann,

 

first, think about ITEM formula, let's check Anapedia (https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/ITEM.html)

 

"Returns the list item of a list-formatted or time period-formatted line item."

 

Therefore, to return list item, this list needs to be a dimension in your module. That answers your question - you need to have G1 Region as a dimension in your module. SYS02 Region Details is system module, the only dimension will be G1 Region and line items in which you want to store details of Region list members e.g. Code.

 

Let me know if you have other questions!