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

See if this helps:

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

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

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

Does this work for you?

OvertimeByWeek.fp7.zip

Awesome, that worked.

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

Many thanks, you saved my bacon.