Summarise on Formula Field

[rpmel]

Hi Everyone!

I've created a report to measure leadtime taken from the time a customer places an order, to the time it gets invoiced on dispatch.

I've used Ken Hamady's workday formula, and then created another formula field called ONTIME, which looks like this:

If {@WORKDAYS} <= Average ({@WORKDAYS}) then
1 else 0

The idea being, to calculate the average leadtime, and then count up how many orders were processed, and of those, how many were within the average leadtime.

I'm stuck on the summary - the formula above flags all the orders correctly, but I don't get an option to summarise on the ONTIME field if I use INSERT | SUMMARY.

The field is formatted as a number, so why can't I summarise on it?

Any ideas?

 

[IdoMillet]

You can sum it because it depends on a summary.

Instead, use a variable and increment it when the condition is true.

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[rpmel]

Thanks IdoMillet,

Can you please give me some help? How do I do that? I've only been messing around in Crystal for a week. I'm using Crystal XI.

 

[IdoMillet]

Start by reading Online help about variables. Then, if you have a question, fire away...

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com