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.
Tagged:
1
Best Answer
-
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/0
Answers
-
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).0
