Dynamic Numbered List

Hi,

I have Months as a numbered list. The number of items in this list is calculated based on user input. Each time the user changes the input, the list should be deleted and items should be created based on the new value. Is it possible to dynamically create the number of items in a numbered list?

Thanks

Accepted answers

KirillKuznetsov

I would suggest to create a subset for your Month list (month list will have the maximum of the months you expect users will need - for example 500). A TECH module with dimension of months list will analyze input and check (boolean) if the number of each period is bigger than the calculated required starting month number (5) and smaller than the ending month (485). This boolean you will use for import into the subset. Within this import action you will have to clear out the subset. For this you can create one more line item formatted "No Data" in this TECH module and setup an import to the subset to clear it out.

Than this subset can be used wherever you need.

All comments

KirillKuznetsov

@NivyaRthere are various ways to achive it. Could you specify what user inputs? What should drive the list fulfillment?

NivyaR

The User would input 'Start month' and 'Term'. I then calculate the number of months to show as (12*Term + Start Month) For Ex: if User inputs Start Month as 5, Term as 40 (Years) Then number of months required to show in the list would be 12*40+5 i.e. 485. Month list should now have 5,6,7,8..,484,485

KirillKuznetsov

Than this subset can be used wherever you need.

NivyaR

Thanks a ton!! It worked 🙂

Quick Links

Can you help?

Unanswered questions

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…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…