Another Date Question...

[hebuna]

Piggybacking on the previous post. I'm using SQL Server & CRXI. I am using the previously mentioned formula of Mr. Hamaday's {@Workdays} to calculate the number of workdays in a month. But here is what I need now.

I have 10 technicians. I'm trying to figure out the average number of calls per day that each technican completed for the month. But - there may be days that a tech was on vacation or sick that I need to subtract from the number of workdays. Right now I have:

{Count of SCCalls.CallNumber} / {@Workdays} which works fine for the total work days of the month. I am not sure how to set something up to ask for the number of days to subtract and then how to place that answer into the {@Workdays} formula. I would need to have the question asked for each technician. I was thinking a parameter but I have no idea how to make that work.

I know this is probably clear as mud as to what I'm trying to do - so please let me know if you need more clarification. Thank you - will greatly appreciate any ideas!

 

[MrBillSC]

If your are prompting for days off per tech, the average calls per day formula might be modified as follows:

// formula {@avgCalls}
If {table.techId} = 1 then
({Count of SCCalls.CallNumber} / ({@Workdays} - {?Tech1DaysOff})) else
If {table.techId} = 2 then
({Count of SCCalls.CallNumber} / ({@Workdays} - {?Tech2DaysOff})) etc.

MrBill

 

[hebuna]

Thank you - That makes sense to me. But now the question is presented of how do I set up the prompt to enter the days off? I have very little experience in setting up parameters so I'm baffled!

 

[hebuna]

I think I got it! Thanks for your help!