Sum of Weighted Value 1

[globularbob]

Hello

I am stumped. I am trying to sum the score of a weighted value. The field I am trying to sum contains the following formula:

((PlatAHT}-{AHT})/{StdDevAHT})*({nch}/Sum (nch}, (Fullname})*100

In summary, I want to create a total weighted statistical Z score. I realize that the formula fails when I try to derive the percent of nch to the sum of nch to get the %. Is there any way to do this????

Thanks in advance!!
Bob

 

[pgtek]

Hi
try this
totext(sum(PlatAHT}-{AHT})/{StdDevAHT})*({nch}/Sum (nch}, (Fullname})*100,3)+"%&quot
cheers

pgtek

 

[synapsevampire]

A bit vague, such as where this formula is, what exactly you want, but if all you want to do is sum that formula, try:

Group Header for Fullname:
numbervar MySum:= 0;

Group Footer for Fullname:
numbervar MySum:= MySum+
((PlatAHT}-{AHT})/{StdDevAHT})*({nch}/Sum (nch}, (Fullname})*100;

Report Footer: //Used to display the sum
numbervar MySum

-k

 

[globularbob]

Hi

Thanks to both for the quick replies! The formula is in the details section, and I'm trying to put the sum of the weighted average in the associate's name group.

Again, thanks!!

bob

 

[globularbob]

SynapseVampire,

I created 3 formulas: one for the header, one for the detail, and one for the footer. Each header and footer return 0, but the detail is a running total.

What am I missing?

Tons of thanks!!

 

[globularbob]

I got it!

Thanks for all of your help. I just had to noodle with the placement of the header and footer formulas.