Calculation for Available Hours in Group Summary

[arachnoid]

Using CR XI, I am attempting to calculate the difference between the available hours using the following data set.

WO# Due Date AVL Hrs.
John Smith
12345 03/02/07 160

23456 03/30/07 320
34567 03/30/07 320

Group 1 is on Resource ("John Smith")
Group 2 is on Due Date
AVL Hrs. is a calc of available hours based on a 40 hour work week and is a summary of the available hours from today through the Due Date.

What I'm trying to accomplish is to reset the summary between Due Dates. For example the actual AVL Hrs. for the tasks due on 3/30 is 160, not the 320 that the summary returns.

I need a formula or calc that will allow me to find the difference between the hours available between due date 1 and due date 2 and so on.

Any help would be greatly appreciated.

 

[Madawc]

What exactly are you doing? You say 'summary', but it looks more like a running total where you have failed to set the right entry on the third section, reset.

If you're not already familiar with the difference, the basics are explained at FAQ767-6524.

Also consider using a crosstab.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

You need to show the contents of the calculated summary. If it is a formula equivalent of a simple inserted summary, be sure to use the date group as the second argument, as in:

sum({table.amt},{table.date})

Or more simply, right click on a detail level calculation ->insert summary->choose the date group.

-LB