Thanks for the test case. It seems to work for me. If I have a Min of -23 and Max of 20 there are four rows displayed including -22. Same if I change Min to -22. But when I change to -21 the row with -22 is removed.
Please provide the steps to show how this doesn't work with negative numbers.
I wouldn't expect this to display any rows since -25 is less than -21. The min <= valcol && valcol <= max portion of the if statement affects this. There wouldn't be a condition where -21 <= valcol and -25 > valcol. If you want this for negative numbers you would need to change the if statement. But you wouldn't be able to have both min -21 max -25 and min -25 max -21 work.
Replies
Thanks for the test case. It seems to work for me. If I have a Min of -23 and Max of 20 there are four rows displayed including -22. Same if I change Min to -22. But when I change to -21 the row with -22 is removed.
Please provide the steps to show how this doesn't work with negative numbers.
Kevin
column "AGE"
min -21 max -25 NOT WORK
min -25 max -21 WORK
I wouldn't expect this to display any rows since -25 is less than -21. The
min <= valcol && valcol <= maxportion of the if statement affects this. There wouldn't be a condition where -21 <= valcol and -25 > valcol. If you want this for negative numbers you would need to change the if statement. But you wouldn't be able to have bothmin -21 max -25andmin -25 max -21work.Kevin