Grouping Formulas

[rcorrea]

Hello,

I have a report that is pretty basic:

Report is grouped by a date diff formula and has a formula for counting records based on the group

Ex.
Business days # of records

1 22
2 10
3 5
4 11
5 9
6 10
8 6
11 3

I now want to create a new group that will group <=3 days, <=5 days, between 4 and 10 days, and >10 days..my result would be this

Business days # of records
<-3 37
<=5 57
4 - 10 days 16
>10 3

Thoughts?

 

[Madawc]

Create a formula field, something like

 if {days} < 3 then "a) <-3"
else 
if {days} < 6 then "b) <=5"

Continue like this, except your third range should be 6 to 10, unless the second is not what you meant.

It's best to give your Crystal version, answers sometimes vary depending on version. In this case there should be no problem.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[rcorrea]

Thank you Madawc..using Crystal 8.5

What I get now is this

<=2 22
<=2 10
<=3 5
<=5 9
<=5 11

doesn't seem like it's grouping them..

 

[rcorrea]

Disregard..got it to work.

Thanks for the help.