Help with StdDev and Avg formula

[gamble1]

Hello,

Trying to make this formula work:

0.005 - Average ({@C1Avg}) / StdDev ({@C1stdev})


C1Avg formula is:
{eptData.Err2} / {eptData.BlocksWritten} * 10 / 1024 * 3

C1stdev formula is:
{eptData.Err2} / {eptData.BlocksWritten} * 10 / 1024


Is this possible?

 

[kenhamady]

Looks OK, just be sure you aren't dividing by zero in any records. Are you getting an error? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[gamble1]

Hi,

No not getting any errors, but I'm not getting the right numbers back. (I have calculated manually the Stdev and Avg I need). Would it help if I sent you the report?

Thanks!!

Sue

 

[kenhamady]

Are the C1 formulas giving you the corrrect numbers by themselves? It might be that you need parenthesis to tell it which operations to do first.

Then I would do the summaries of these to columns separately to see which is wrong. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/