Help displaying all bins on a chart

[Charley71]

I have a chart that on of the axis is based off a formula called buckets that looks like this:
if {@megs} < .10 then "0.00 to 0.10" else
if {@megs} < .50 then "0.11 to 0.50" else
if {@megs} < .69 then "0.51 to 0.69" else
if {@megs} < .99 then "0.70 to 0.99" else
if {@megs} < 1.5 then "1.0 to 1.5" else
if {@megs} < 2.0 then "1.6 to 2.0" else
if {@megs} < 3.0 then "2.1 to 3.0" else
if {@megs} < 5.0 then "3.1 to 5.0";

I want to display all the buckets whether there is data for them or not. Currently I can only get it to display the buckets that have data for them. I would like it to show all 8 buckets and just put a zero over them if nothing falls within them. Is this possible? (crystal reports 11) Thanks

 

[lbass]

I think you would have to use separate running totals for each bucket, and then add each running total to the chart as a show value field.

-LB

 

[Charley71]

I am having trouble with that. I can get the buckets but there isn't a way to count the assets. I made 8 bucket formulas.

So for {@bucket1} could I add in the count for the Assets.

Something like:

if {@megs} < .10 then "0.00 to 0.10" count (assetnumber)

I am unsure of what the syntax for this would be.

 

[lbass]

I was suggesting running totals where you do a count of assetnumber, evaluate based on a formula:

{@megs} < .10

Reset never. Change the evaluation formula for each bucket running total.

-LB