Input Field: Value Range in IP Web Layout

[former_member125971]

Hi Experts,

I've created a Web Layout based on IP with a copy function (e.g. from actual 2008 to plan2009) over 12 calendar months. For choosing the months to be copied, I created a Variable (calmonths) and added an Input Field into my layout to enter the the months to be copied. I referred the variable to the input field and it's working...

When I want to select several months to be copied, I can type in " 1; 2; 3; " into the input field, execute the planning function and only month 1, 2, 3 (i.e. Jan, Feb, Mar) are being copied. But when I want to copy all 12 months, i have to enter 1; 2; 3; 4;...11; 12 which is kind of anoying! Has somebody some experience whether I can use a value range like 1-12 (or something like that) to avoid entering all the months individually? (I tried 1-12; 1- 12; 1 - 12; 1:12 etc but nothing like this is working)

It would be very helpful if someone has an idea

All the best,

Norbert

[Former Member · Accepted solution]

Did you try using a variable of type 'value range'?

[former_member125971 · Accepted solution]

Hi Mayank,

Thanks for your quick reply!

When creating a variable, I can only choose between 'single value' and 'multiple values'. There is no option to choose 'value range'.

Got another idea?

BR,

Norbert

[Former Member · Accepted solution]

Hi Norbert,

There should be more types - Interval, Selection option etc...

I meant you to try 'Interval' (I wrote 'value range').

[Former Member]

Hi,

You should be able to find the variable of type 'Value Range' in the type of variable drop- down.. This will help out.

Regards,

Srinivas.

[former_member125971]

Hi Mayank, hi Srinivas.

Thanks a lot for your valuable input! Unfortunately I was not able until today to test your recommodations.

I tried your Interval variable but then faced the problem that I cannot enter multiple months anymore (e.g. 5 - 8 worked, 1; 3; 5 not). Then I inserted both variables, multiple values & interval, into the planning function as well as in the button group in WAD for executing the PF but was not able to execute the following example: 1; 8; 4 - 6. After trying out for some time I figured out that one has to type in the figures in the following order: 4 - 6; 1; 8. Only then I am able to execute the planning function for the months April-June & Jan & August. So, if you're facing the same problem in the future, maybe you have the solution

Best regards,

Norbert

[Former Member]

Hi Norbert,

In the Interval variable, if u want to copy from April to June, give the values as 4-6 (which u said is working for you), and if u want to copy for only Jan, give values as 1-1, and for August give as 8-8.

You need not create both Interval and multiple value variables. Only interval variable would suffice in this case.

Hope this will resolve your problem.

Regards,

Srinivas Kamireddy.

[former_member125971]

Hi Srinivas,

you are right, I could also do this by entering the month March by 3 - 3. But what we wanted to do is being able to enter single values and also a value range at one into the input field, e.g. 1; 3-5; 11-12.

Right now I got to see, that some characteristics (such as calmonth) are not supporting an interval-section... But I'm able to execute the planning function with one interval and several single values (3 - 7; 1; 11) but not if I only enter an interval section (3 - 7). Here I have to enter it the following way: 3 - 6; 7. Strange, but this is how the system tells me.

Best regards,

Norbert