<p>I have a table and it has customers and various details in. Each customer has a certain number assigned to them:</p>
<ol><li>0</li>
<li>50</li>
<li>90</li>
<li>91</li>
<li>99</li>
</ol><p>I'm trying to group them together by number but it isn't working so well. It groups them but isn't always accurate. The formula I've got working best is below:</p>
<p> </p>
<div>
<div style="color:rgb(0,0,0);font-family:Tahoma;font-size:medium;">
<div>
<div><span style="font-size:10pt;"><b>for</b></span> <span style="font-size:10pt;">(i=11; i<500; i+=11){</span></div>
<div><span style="font-size:10pt;"><b>if</b></span> <span style="font-size:10pt;">( row[</span><span style="font-size:10pt;">"CTST"</span> <span style="font-size:10pt;">] < i ){</span></div>
<div><span style="font-size:10pt;">rangeStart = i-11;</span></div>
<div><span style="font-size:10pt;">rangeEnd = i-9;</span></div>
<div><span style="font-size:10pt;"><b>break</b></span> <span style="font-size:10pt;">;</span></div>
<div><span style="font-size:10pt;">}</span></div>
<div><span style="font-size:10pt;">}</span></div>
<div><span style="font-size:10pt;">displayString = rangeStart + </span><span style="font-size:10pt;">" - "</span><span style="font-size:10pt;"> + rangeEnd;</span></div>
</div>
</div>
</div>
<p> </p>
<p>the ranges it comes up with are as follows:</p>
<ol><li>0-6 (hits 0 range)</li>
<li>44-50 (hits 50 range)</li>
<li>88-94 (hits 90 range)</li>
<li>91 range value is not created for some reason</li>
<li>99-105 (hits 99 range)</li>
</ol><p> </p>
<p>It hits every value the customers have other than 91 - BIRT acknowledges it and breaks it off into a new group like it does with the rest of them but does not display any kind of range like it does with the others - I've tried changing the range multiple times but it never gives me a range value for those with a value of 91. Does anyone know why?<br><br>
*Edit* If I un suppress the column it sits in it displays it as 88-90 when it should be a new range as 91 doesn't come into 88-90.</p>
