Summary of a Calc field that includes GetSummary - help!

[hal9000]

I'm trying to define a summary field that summarizes a calculated field that as part of its calculation includes getsummary on another field.

I defined the field, but the result are whack! I have attached the fp7 in a zip and a pdf showing the whacky total regular hours calculation. (712.8 and 600.0)

Any help would be appreciated. The accounting department is breathing down my neck!

Thanks!

TimeKeeper.fp7.zip

TimeKeeper.pdf

[comment]

See if this helps:

http://fmforums.com/forum/showtopic.php?tid/209850#334676

[hal9000]

Thanks, that helps me to understand what's going on, and that may ultimately lead me to the solution, but for now, I'm still stuck.

The reason is, I can't just sum the count of detail records because that gives me an average. For example:

11 entries sum to 40.0 hours (11 * 40.0 = 440.0)

8 entries sum to 34.1 hours ( 8 * 34.1 = 272.8)

The total I need to get to is 74.1 (40 + 34.1)

The total I get by dividing 712.8 by 19 is 37.5

[hal9000]

And when I move that calculation up to the preceding summary level, I'm back where I started, with an inflated total.

[comment]

Does this work for you?

OvertimeByWeek.fp7.zip

[hal9000]

Awesome, that worked.

I guess I was missing the serial# field to do a proper count.

Many thanks, you saved my bacon.