Unique ID Number

[PrevContributor]

Is there a way to have my Anaplan model assign a unique identifier number to line items in a budget? I plan to load a budget into my model and would love for the system generate a unique identifier number for each item in order to reduce risk of human error. Currently in my Excel budget file, the unique identifiers are created manually which gives to a risk of duplication.  

[PrevContributor · Accepted solution]

In order to identify each item uniquely a NUMBERED LIST will serve this request. A unique number gets generates for each item when the data is entered/imported in to the list. Reference Link : https://community.anaplan.com/anapedia/model-building/lists-and-roll-ups/numbered-lists/working-with-numbered-lists/

[peter_mcanena]

Alternatively, you could use a formula like this:

RANK(Sort Value, ASCENDING, SEQUENTIAL)

where Sort Value is any line item in the module (as long as that line item has all the relevant dimensions).