Numbered Lists

Hi,

I have a numbered list, in which i want the numbers to start from 1.

I have used this list as dimension also have referred in some formulas.

i entered wrong numbers when i was inserting numbers to the list. Now when i enter the numbers it starts from the next index number.

is there any way i cant reset it?

Capture 2.PNG

Thank You

Accepted answers

kavinkumar

HI @Adhvi.Panata,

Yes there is a way to reset if you are a Workspace Admin. Please note you can reset the Next Item Idex only if the count reaches 899,999,999. Have a look at the below post which is related.

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Numbered-Lists-renumbering/m-p/44316#M5175

Or create a new list and reference it.

I hope this helps.

Thanks,

Kavin.

Adhvi.Panata

thank you @kavinkumar @VIGNESH.M

VIGNESH.M

Hi Adhvi,

Instead of referring to the index number, use properties or line item to calculate the numbers. This will give what you are expecting.

Try this,

Thanks,

Vignesh M

All comments

kavinkumar

HI @Adhvi.Panata,

Yes there is a way to reset if you are a Workspace Admin. Please note you can reset the Next Item Idex only if the count reaches 899,999,999. Have a look at the below post which is related.

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Numbered-Lists-renumbering/m-p/44316#M5175

Or create a new list and reference it.

I hope this helps.

Thanks,

Kavin.

VIGNESH.M

Hi Adhvi,

We can reset the number list, after it reach its maximum 899,999,999 Million.

So we can't reset in your case.

~Vignesh M

Adhvi.Panata

thank you @kavinkumar @VIGNESH.M

VIGNESH.M

Hi Adhvi,

Instead of referring to the index number, use properties or line item to calculate the numbers. This will give what you are expecting.

Try this,

Thanks,

Vignesh M

DavidSmith

@Adhvi.Panata

A simple and more efficient answer, is to always ensure that you use a code for the numbered list and use that for the display name using CODE(ITEM(listname))

David

Quick Links

Can you help?

Unanswered questions

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…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…