Crystal Report graph

Hello,

On the second data axis, I'm trying to use the running total parameter called {#Efficiency Week Total}. It's not available for use. The value in the 3-15 week should be 0.38 as it is in the subreport below. If running totals are not available for use in a graph, how else can I accomplish this?

Thanks for your help. I've attached the files. The main report is the one that ends in EE.

Joel
Engineer-EfficiencyEE.rpt
Engineer-EfficiencySub.rpt

Crystal Reports

Last Comment

Genius123

8/22/2022 - Mon

Mike McCracken

9/15/2015

Change the chart to use Distinct COunt on the Engineer field.

By counting your COuntEngineers summary it is always the same value for a week.

mlmcc

Genius123

9/15/2015

ASKER

mlmcc, I'm sorry but I had since edited the question. could you take another look?

Mike McCracken

9/15/2015

Try using this formula

Sum ({@Total Hours}, {tblRevisions.CheckerComplete}, "weekly") / 40 / DistinctCount ({tblRevisions.Engineer}, {tblRevisions.CheckerComplete}, "weekly")

mlmcc

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

rwheeler23

Genius123

9/15/2015

ASKER

It's not working. Part of the formula that is not working is this:

DistinctCount ({tblRevisions.Engineer}, {tblRevisions.CheckerComplete}, "weekly")

It returns a value of 1 for each week in the chart. The values should be like 6 or 7 or 8.

ASKER CERTIFIED SOLUTION

Mike McCracken

9/15/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Genius123

9/15/2015

ASKER

You were right, it was the grouping. The final fix was to make a subreport for the chart, delete the first grouping by engineer, and change the formula to this:

Sum ({@Total Hours}, {tblRevisions.CheckerComplete}, "weekly") / (40 * DistinctCount ({tblRevisions.Engineer}, {tblRevisions.CheckerComplete}, "weekly"))

Thanks for your help!