Number of days distribution formula

[TheBlondOne]

I am trying to create a report using crystal reports 6 that uses the number of days a call has been open as a frequency. i.e Less than 1 day, between 1 & 2 days, between 2 & 3 days, between 3 & 6 days, under 1 week, over 1 week.

The formula i am using is (this doesn't work by the way)

If {@Number of Days} <1 then &quot;Less than 1 day&quot; else
If {@Number of Days} >=1 and < 2 then &quot;Between 2 & 3 days&quot; else
If {@Number of Days} >=2 and <3 then &quot;Between 3 & 4 days&quot; etc...

I am a little stuck on how to do this, can anyone help?

 

[Andie]

You are on the right track. However, you need to have the field name listed each time you want to check it:

If {@Number of Days} <1 then &quot;Less than 1 day&quot; else
If {@Number of Days} >=1 and {@Number of Days} < 2 then &quot;Between 2 & 3 days&quot; else
If {@Number of Days} >=2 and {@Number of Days} <3 then &quot;Between 3 & 4 days&quot; etc...

 

[TheBlondOne]

Cheers, that should do it.