count sub summary

[Cateleb]

Hi  I've seem to have hit a mental block .. it might be easy and I'm thinking too hard about it

Below is a screen of a layout with 2 sub summaries 1st - contractorID and 2nd the number of days worked each month based on their time sheets (using an inverse count calc / summary field someone here gave me a while back :-) .. where they might do multiple time sheet records on a particular day, but it's just counted as 1)    As you  can see, some didn't do any work during a particular calender month so it doesn't show.  What I need to do is count the number of months showing  ie for contrator 458 it's 3, for 643 it's 1 .. I then can do an averge days worked, BUT I can only use the months worked, ie 458 = 69/3   548 = 14/2 etc  .. it's to calculate if payroll tax is applicable

 

cheers

cate

Edited May 9, 2017 by Cateleb
the screen jpg didn't embed, now attached

[comment]

1 hour ago, Cateleb said:

the number of days worked each month based on their time sheets (using an inverse count calc / summary field someone here gave me a while back :-) .. 
...
What I need to do is count the number of months

Count the months using the same method you're counting the days.

[Cateleb]

doh ! .. I knew it would be simple .. I had acually created the fields but for the summary I used 'Count of' instead of 'Total of'

thanks Comment