BAQ/Crystal Report for Late Deliveries

Yahoo Archive
1
You can do this really easy in a running total field. Just add a formula
that returns true/false on when to include a row in a count.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brad Ebright
Sent: Thursday, January 28, 2010 8:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ/Crystal Report for Late Deliveries





Could you group it by late and on time deliveries and then do a summary
based on that? All you then would have to do is do a simple formula to
divide the two summary fields.Does that make sense?

Thank You,

Brad Ebright
MGS Inc.
178 Muddy Creek Church Rd.
Denver, PA 17517
(717)336-7528

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
SeanT
Sent: Thursday, January 28, 2010 8:06 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ/Crystal Report for Late Deliveries

Hello,
I am attempting to create a BAQ Report showing our "On-Time Delivery
Rating". This rating would be calculated by dividing the number of lines in
which we were late by the total number of lines.
I am having a little trouble with this in Crystal Reports. I am trying to
get the report to count the number of late lines, but so far it will only
count the total number of lines. I thought about using the select expert to
filter out all lines except late ones, but then I wouldn't be able to divide
by the total number of lines (since the on-time ones would have been
filtered out).

Any ideas on how to make this work?

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
Hello,
I am attempting to create a BAQ Report showing our "On-Time Delivery Rating". This rating would be calculated by dividing the number of lines in which we were late by the total number of lines.
I am having a little trouble with this in Crystal Reports. I am trying to get the report to count the number of late lines, but so far it will only count the total number of lines. I thought about using the select expert to filter out all lines except late ones, but then I wouldn't be able to divide by the total number of lines (since the on-time ones would have been filtered out).

Any ideas on how to make this work?
3
Create a calculated field for "late":

If line is late formula = 1 if it is on time =0. then just sum that
field.

Terry S Ellis
Consultant
716-983-8827

Sent from my mobile device

On Jan 28, 2010, at 8:05 AM, "SeanT" <seantoler@...> wrote:

> Hello,
> I am attempting to create a BAQ Report showing our "On-Time Delivery
> Rating". This rating would be calculated by dividing the number of
> lines in which we were late by the total number of lines.
> I am having a little trouble with this in Crystal Reports. I am
> trying to get the report to count the number of late lines, but so
> far it will only count the total number of lines. I thought about
> using the select expert to filter out all lines except late ones,
> but then I wouldn't be able to divide by the total number of lines
> (since the on-time ones would have been filtered out).
>
> Any ideas on how to make this work?
>
>


[Non-text portions of this message have been removed]
4
You could make a Formula Field that determines if the delivery is late and
another Formula Field to determine if it was on time, summarize both of
these fields by PO and do the on time / late calculation on the summarized
fields.



Gerry



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
SeanT
Sent: Thursday, January 28, 2010 8:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ/Crystal Report for Late Deliveries





Hello,
I am attempting to create a BAQ Report showing our "On-Time Delivery
Rating". This rating would be calculated by dividing the number of lines in
which we were late by the total number of lines.
I am having a little trouble with this in Crystal Reports. I am trying to
get the report to count the number of late lines, but so far it will only
count the total number of lines. I thought about using the select expert to
filter out all lines except late ones, but then I wouldn't be able to divide
by the total number of lines (since the on-time ones would have been
filtered out).

Any ideas on how to make this work?





[Non-text portions of this message have been removed]
5
Could you group it by late and on time deliveries and then do a summary
based on that? All you then would have to do is do a simple formula to
divide the two summary fields.Does that make sense?



Thank You,



Brad Ebright
MGS Inc.
178 Muddy Creek Church Rd.
Denver, PA 17517
(717)336-7528

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
SeanT
Sent: Thursday, January 28, 2010 8:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ/Crystal Report for Late Deliveries





Hello,
I am attempting to create a BAQ Report showing our "On-Time Delivery
Rating". This rating would be calculated by dividing the number of lines in
which we were late by the total number of lines.
I am having a little trouble with this in Crystal Reports. I am trying to
get the report to count the number of late lines, but so far it will only
count the total number of lines. I thought about using the select expert to
filter out all lines except late ones, but then I wouldn't be able to divide
by the total number of lines (since the on-time ones would have been
filtered out).

Any ideas on how to make this work?





[Non-text portions of this message have been removed]
6
I was thinking that I would have to do this using a formula or formulas in Crystal, but the calculated field worked great.
Thanks!

--- In vantage@yahoogroups.com, "Terry S. Ellis" <tse@...> wrote:
>
> Create a calculated field for "late":
>
> If line is late formula = 1 if it is on time =0. then just sum that
> field.
>
> Terry S Ellis
> Consultant
> 716-983-8827
>
> Sent from my mobile device
>
> On Jan 28, 2010, at 8:05 AM, "SeanT" <seantoler@...> wrote:
>
> > Hello,
> > I am attempting to create a BAQ Report showing our "On-Time Delivery
> > Rating". This rating would be calculated by dividing the number of
> > lines in which we were late by the total number of lines.
> > I am having a little trouble with this in Crystal Reports. I am
> > trying to get the report to count the number of late lines, but so
> > far it will only count the total number of lines. I thought about
> > using the select expert to filter out all lines except late ones,
> > but then I wouldn't be able to divide by the total number of lines
> > (since the on-time ones would have been filtered out).
> >
> > Any ideas on how to make this work?
> >
> >
>
>
> [Non-text portions of this message have been removed]
>