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.
Solved! Go to Solution.
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).