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

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…