Subset functions - average bus hours

rajeshbalu29 · November 10, 2011 5:18AM

Hi, I have to calculate the sum of bus hours / count of tickets. I have created a function for making the count of tickets as below
=RECORDCOUNT(SUBSET2([Month],[Type],[Month]))
but I am unable to find a function for totalling the bus hours for the whole month. Can anyone help me on finding a formula for getting the sum of bus hours per month?

tjbate · November 10, 2011 6:01AM

Rajesh - If your data set has one row per ticket ID, and hours spent per ticket is also in each row, then the formula could be:

SUBSET_SUM ([Hours]),SUBSET([Month],[Month]) /
SUBSET_NONEMPTYCOUNT([TicketID]),SUBSET2([Month],[Type],[Month], "type")

if you wanted to specify only a certain value for "type", otherwise [Type] to calculate for each type for each month.

rajeshbalu29 · November 10, 2011 11:32AM

Thanks and it did worked perfectly....

Welcome!

Categories

Ideas Parade

Tagged