Recent content by relaxinjim

Thanks for the quick response. I'll test it out this evening! Jim

I am using Crystal 9. I am interested in selecting particular dates (the first and last date) within a group. My report is organized as follows: ID DATE OTHER DATA GROUPED ID (100) 100 4/05 xxxxx 100 6/05 xxxxx 100...

You got it! This code works like a charm. Thank you very much.

Thank you for your input LB. I inserted your code into the denominator with the appropriate fields and received an error message when I checked the formula: "This array must be subscripted. For example: Array [i]." I don't know anything about arrays so this is greek to me. I did try to...

Thank you for the response Madawc. I have not been able to construct the divisor as you indicate. My situation relates to you second instance "If they all come from the same row, then you'll need to long-windedly cover all possible combinations of zero and non-zero." This presents a cumbersom...

I am using Crystal 9. I am interested in calculating the average of multiple fields 'horizontally' in a report. I set up a formula adding the fields and then dividing by the number of fields: (fld1 + fld2 + fld3 + fld4)/4 (3 + 2 + 4 + 3)/4 = 3 This returned me the correct answer for most...