NUMC characteristic with a range + offset restriction

[Former Member]

Wondering if someone knows a way to fix this:

I built a report that has a characteristic that contains the numerical difference between two dates. then I setup columns that filter a range 0-5, 6-10, 11-15, 16-20. Up to now everything works fine.

Now, a last requirement is implemented which breaks the whole thing:

They must be able to specify a grace period to this range of dates. So what I did is I setup a variable on this characteristic and setup my ranges as shown below:

(the + are set as offsets to teh variable)

0-5 grace to grace+5

6-10 grace6 to grace10

and so forth.

If I run this report with the variable containing 0 (actually #), it works fine. But the moment I try to change this vaue I get:

Message: Moved value is not within the allowed value range

Diagnosis

You wish to move the value of a variable. The result is consequently no longer in the permitted value range.

System response


Procedure


Procedure for System Administration

 
 
  Notification Number BRAIN 617  

Anyone has a clue how to get around this? The only thing I found so far would be to apply the grace period to a report filter like >grace. This way though my column ranges wouldn't be dynamic and if someone chose a grace of 5, the 0-5 column would be empty and so on... Not the perfect solution... Anyone has something better? (I always give proper points).

[Former Member]

Thanks all for your help

This was a code 18 error...

In case you wonder:

One of my ranges (the >20) actually contained

Grace21 to Grace999

So the moment grace>=1 my value became >1000 which is bigger than the characteristic which is 3 characters...