Unique ID Number

Highlighted
Previous Contributor

Unique ID Number

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.  

2 REPLIES 2
Highlighted
Previous Contributor

RE: Unique ID Number

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/
Highlighted
Regular Contributor

RE: Unique ID Number

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).