Formulas with grouped data

[Former Member]

In my report, I am grouping data by Workcenter, Shift, and Part Number.  For each group of data, I need the Total Part Number Quantity, Total Part Number Lapse Time, and Average Per Hour.

I was able to get the Total Part Number Quantity and Total Part Number Lapse Time easily using group summary.  But have not found a way to get the Average Per Hour.   Total Part Number Lapse Time is in seconds.

To get the Average Per Hour, I would need Total Part Number Quantity divided by Total Part Number Lapse Time multiplied by 3600.

I am using SAP Crystal Reports 2011 version 14.0.3.613 RTM.

Attached is an example of what the report should look like.

I can the correct values for TOT_PARTS column and TOT_LAPSE column.

How to use the TOT_PARTS value and TOT_LAPSE value to get the Average Per Hour?

Please help!

Sincerely,

Keith Jackson

[abhilash_kumar · Accepted solution]

Hi Keith,

Create a formula with this code and place this on the Group Footer:

(Sum({Part_Qty2}, {Group_Field})/Sum({Part_Lapse_TM}, {Group_Field}))*3600

-Abhilash

[Former Member · Accepted solution]

Thanks Abhilash!  That worked great.