Dynamic Numbered List

NivyaR
New Contributor

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
KirillKuznetsov
Certified Master Anaplanner

Re: Dynamic Numbered List

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.

 

View solution in original post

4 REPLIES 4
KirillKuznetsov
Certified Master Anaplanner

Re: Dynamic Numbered List

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

NivyaR
New Contributor

Re: Dynamic Numbered List

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
Certified Master Anaplanner

Re: Dynamic Numbered List

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.

 

View solution in original post

NivyaR
New Contributor

Re: Dynamic Numbered List

Thanks a ton!! It worked 🙂