howdy again kirvis,
remember this thread?
While I'm sure that one of the folks on the board can come up with a custom function (and that it may be your preferred method based on your post) the approach I outlined in the other thread would be amenable to averaging via summary field.
Food (pastries apparently) for thought...
Yes, I do remember your previous post on this similar question I posted earlier.
I however prefer a custom function, to prevent the system from becoming too extensive as it already is quite large. The TypeSumField function works like a charm for me, and prevents me from having to add a dozen or so additional fields with the if-function in the calculation as you suggest.
It is however an option if nobody else here can come up with a custom function that does the trick at once. Thanks again for your reply.
Thank you for your posts.
If the first calculation gives you a total, then an average would be the total divided by the number of occurrences. Wouldn't that be Total/End? Or, is this a weighted average?