IntervalMatch - Ranges not mapped

[#1]

I am analyzing certain group of students deposits. I want to count the number of users who has deposits with in the range.

TRANSACTION:

LOAD USER_ID,

     AC_BALANCE,

     MONTH

     FROM

(ooxml, embedded labels);

BAND:

load * inline

[

RangeL, RangeH, Band

0,0.999,       0-1

1,9.999,       1-10

10,49.999,     10-50

50,99.999,     50-100

100,199.999,   100-200

200,299.999,   200-300

300,499.999,   300-500

500,999.999,   500-1000

1000,1999.999, 1000-2000

2000,2999.999, 2000-3000

3000,4999.999, 3000-5000

5000,9999.999, 5000-10000

10000,19999.999,10000-20000

20000,100000,  20000-100000

];

DEP_BALANCE:

IntervalMatch(AC_BALANCE) load

RangeL, RangeH

resident BAND;

I have manually checked the data I do not have any user who has more than 25000 balance.

DIMENSION; Band

EXPRESSION: =Count(DISTINCT USER_ID)

Final chart I am getting as follows. The last range contains 75 users and I checked  few of these users and they have a balance of 45.625  It should be mapped under 10-50 range. I am unable to figureout what mistake I am making.

Can I request your help?

Thank you

[#2]

can u post ur Dec2012 file ?