Search results for query: *

question. I see the "great post" on each post. Is it necessary to tag each post in the entire communication or perhaps just the one with the answer?

@skipvought Will do, sorry I'm new to forums.

THANKS AGAIN FOR YOUR TIME!!

THANK YOU - SUCCESS AGAIN SAFE TRAVELS SUGGESTIONS ON HOW TO FIND GOOD TRAINING ON CRYSTAL IS APPRECIATED.

CoSpringsGuy Yes need the single highest total hr for employee subtracted from the sum. Yes I did that calculation incorrect by dividing by 6 - it should be divided by 5 since the 1 max ee count must be taken out. thank you.

CoSpringguy THANK YOU. using your formula I get result but it's a smidge off from my manual calc. Just to be clear if we used this last formula on your example above I should arrive at 35.17. That's total hours (255.50 - 44.50)/6 employees. The current result is off .10 from my manual...

Absolutely I will try it on my own. thanks for your help. Enjoy your day.

CoSpringsguy: SUCCESS! Thank you. Now what if I wanted an average excluding MAX for ALL employees ALL departments? So as to show as a company total in report footer.

cospringsguy hmm, I think excel is producing a correct result. The excel version does not total labor hours per day per employee. It simply list a value as a total hours per employee. Please advise if you agree with this calculation: Accounting Dept: Employee 1 - total labor hours 44.25...

cospringsguy thank you for your reply. this formula is producing a result however its not the same result that excel is producing. What can I show you so you can see the crystal report design and what the result is.

Not sure if this would help but in excel this formula that would produce my desired result is: =(sum(A1:A3)-MAX(A1:A3))/MAX(1,count(A1:A3)-(countif(A1:A3,MAX(A1:A3))))) where A1:A3 are formulas that total labor hours per the employee/department.

ok. Guess I'm not clear on your terms "sub-sample" and total sample. I need an average of total sample excluding MAX value of the total sample.

Hi Thanks for the reply. Excluding Max to produce average by department only not for report totals.

I'm a very new user to Crystal. I'm trying to create a formula (s) to produce the average of a labor hours excluding the maximum value. Currently this is what I have setup: Report is titled "Average Hrs by Dept" Purpose - labor hours are to be listed for each employee per day grouped by...