1.4.3.2 Import Data & Add Formula

JeemarieB

Hello,

What formula should I use for the code line item? Instructions did not specifically describe the code.

Thank you in advance!

Accepted answers

JaredDolich

Oh, so close @JeemarieB - I should have been more precise. When I wrote "list" you need to put the list you want to address. So it will look close to this, all depends on what you named the list. CODE(ITEM('P3 SKU'))

Notice that when you have any characters that are not alpha numeric, like the number "3", you will have to put the list in single quotes like'P3 SKU'

See if that helps.

All comments

JaredDolich

@JeemarieB

You can use the CODE function which will return a text formatted value. So, CODE(ITEM(List)). If done correctly will look like these codes here.

JeemarieB

Hi Jared,

Formula is invalid on my end. Is there something I'm doing wrong here?

JaredDolich

Notice that when you have any characters that are not alpha numeric, like the number "3", you will have to put the list in single quotes like'P3 SKU'

See if that helps.

JeemarieB

It worked! However,I noticed that the font for the codes changed from blue to black. Is this how it's supposed to be?

JaredDolich

@JeemarieB

Astute observation! Yes, when you enter a formula the font will be black as an indication that the cell will not be editable. Anytime you see a blue font, the cell is editable. Good job! You're quickly becoming an Anaplan Champion.

JeemarieB

Gotcha! Thank you so much for you help!

Quick Links

Can you help?

Unanswered questions

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…