Summarizing Summary Fields - Help!

[mz123]

I have a Client's Table and a Billable Hours table.

On a Client layout, I have a field showing a summary for billable hours for that client.

How can I show a summary of a summary? In other words, in the footer, I want to see the total amount of billable hours for the found set.

Client Hours (Summary)

X 22

Y 20

Z 20

Total 62

How do I create the total row when the Hours are summary fields?

Thanks!

[mr_vodka]

Hi Martha,

Perhaps you can take a look at this thread to see if it will help. By either using Agnes's method or a CF, you can collect the IDs of the found set in a calc and then use a self join to another Hours TO. Then you can reference the same summary field that you use for each clients's hours and it should work for your found set.

http://fmforums.com/forum/showtopic.php?tid/197149

Edited September 17, 2008 by Guest
Added link

[comment]

Do your report from a layout of Billable Hours, sub-summarized by client.

[mr_vodka]

I dont think she wanted this is a report but I am just speculating... :

[comment]

So am I...

If this is for a found set of Clients in Browse mode, then I would use a calculation field in Clients =

Sum ( Billable Hours::Hours )

and a summary field to total the calc.

BTW, there's no link in your first post.

[mr_vodka]

Ah sorry added the link now. :