Good afternoon,

I have two columns: {Count}, {Time}

{Count} can either = 1 or 0, and {Time} always has a certain number of seconds in it.

Ultimately I need sum({Count}) / sum({Time}) which would equal average seconds for the day.

I can't figure out how to do this using the Scriptcase summary feature for an entire day. I can get all the totals of those columns just fine. I can get the average of {Time}, but that counts ALL the records, verse using the total.

How do I get an average of {Time} where it's only divided by the TOTAL of {Count}, not the total record count?

Hopefully that question makes sense. Any help would be appreciated!

Cheers,

Mark.

I have two columns: {Count}, {Time}

{Count} can either = 1 or 0, and {Time} always has a certain number of seconds in it.

Ultimately I need sum({Count}) / sum({Time}) which would equal average seconds for the day.

I can't figure out how to do this using the Scriptcase summary feature for an entire day. I can get all the totals of those columns just fine. I can get the average of {Time}, but that counts ALL the records, verse using the total.

How do I get an average of {Time} where it's only divided by the TOTAL of {Count}, not the total record count?

Hopefully that question makes sense. Any help would be appreciated!

Cheers,

Mark.

## Comment