Showing Negative

[Dukester0122]

I'm trying to get our On-time shipment performance and using this formula:

if {10001.ACTUALSHIP}-{10006.ESTSHIPDATE} > 0 then {10001.ACTUALSHIP}-{10006.ESTSHIPDATE}
else if {10001.ACTUALSHIP}-{10006.ESTSHIPDATE} <= 0 then 0

I tried to create a graph for the results but the On-time days is showing 0%. The specificed Chart Order Group includes 0n-time, 1-10 days, 11-20 days,etc...

 

[Madawc]

Sorry, what are you trying to do? Percentage of what?

If you just want cases where the actual exceeds the estimate, you could test for this in record selection.



Madawc Williams (East Anglia, UK)

 

[Dukester0122]

This report is showing number of days delayed(actual ship date less est. ship date).

Based on the report total, I created a group in my chart which shows On-time, 1-10 days,etc....

The On-time is showing negative percentage.

Is that clear enough?

 

[Madawc]

Use a running total to accumulate those details with a positive number of days delayed.

Right-click on a field and choose Insert to get a choice of Running Total or Summary. Or else use the Field Explorer, the icon that is a grid-like box, to add running totals.

Running totals allow you to do clever things with grouping and formulas. They also accumulate for each line, hence the name. The disadvantage is that they are working out at the same time as the Crystal report formats the line. You cannot test for their values until after the details have been printed. You can show them in the group footer but not the group header, where they will be zero if you are resetting them for each group.

Summary totals are cruder, but are based directly on the data. This means that they can be shown in the header. They can also be used to sort groups, or to suppress them. Suppress a group if it has less than three members, say. They default to 'Grand Total', but also can be for a group.


Madawc Williams (East Anglia, UK)