L1 Model Building - 6 Modules 6.8.2 (Adding Formula)

Good Day

I am struggling to ascertain what I'm doing wrong as the training module informs me that I need to add the following formula: "CODE(ITEM(G1 Region))". However it is giving me the below error message. Please assist. What am I doing wrong? Please see the print screen in the attachment.

thanks

image_85433.png

Comments

chofacker

Hi Nathan,

Without giving it away, take a look at two things 1.) Take a look at your dimensionality for this module. Looks like you are missing something. 2.) Take a look at your formula. Instead of typing in the name of the list you want to reference, go click on the list in General Lists and look at the difference.

Let me know if that doesn't get you the answer you are looking for.

Thanks!

NathanMay

I have been trying to follow your advise but I cant seem to pick up any differences. I have followed the steps over and over and cant see any visible differences. Apologies for these enquiries. The list versus the module and built looks the same. Can you give me more hints please?

NathanMay

I have also realised there is no data in the line items of Code. Could that be the problem?

chofacker

Hi Nathan,

Yes, you will need codes in your list. First, go to the list you are looking to pull codes from and make sure you have codes entered in grid view.

Second, compare my sample code to your original, notice any differences?

Your Original Code - CODE(ITEM(G1 Region))

My Sample Code - CODE(ITEM('G1 Region'))

Third, where you able to determine which dimension you need to add to your module?

NathanMay

Hi Sir

Thanks you very much for your assistance. I finally figure it out. My dimension i did not in in the "Applies To" column "G1 Region".

Thanks for your patients. I really appreciate all your assistance.

Have a wonderful week.

regards

Quick Links

Recent release news

October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…
Recording now available! October 29 platform release event
If you missed our October 29, 2025 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…