find average of % for a group

[rmcguire80]

Hello,

I have a formula which calculates a % for the percent of shipments ontime: ({#count ontime}/(Count ({SHIPMENTS_TTX.RECNO}, {@Project})))*100

for a certain "Project"

I then want to find the average of all of those calculations, how can I do this as they are percent values, so in theory I would total all these percent values up and divide them by the total number of shipments, but it doesn't seem to work and when I just use the average function from within the formula editor it doesn't seem to work either

any help would be appreciated

 

[IanWaterman]

Create another Running Total, that has the same conditions as your existing {#count ontime Overall}, but set reset to never

{#count ontime Overall}

Create another fomula and place this in report footer

@OverallAVG
{#count ontime Overall}%Count({SHIPMENTS_TTX.RECNO})

Ian

 

[CoSpringsGuy]

are you trying to put this in report footer?
I assume{#count ontime} resets on change of group
create another {#count ontime total} that doesnt reset
create formula
{#count ontime}/Count ({SHIPMENTS_TTX.RECNO})*100
or
{#count ontime} % Count ({SHIPMENTS_TTX.RECNO})

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[CoSpringsGuy]

one minute apart Ian .. lol ..

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[IanWaterman]

Great minds think alike ;-)

Ian