Custom function for calculating mode?
I am trying to get a calculation to return the most common value (mode) for a field from a set of records. For instance, if the values in eight records were 1,2,3,3,3,4,4,5 I would want the calculation to return '3'. I assumed there would be a function or custom function to do this, but I cannot find one anywhere. Can anyone offer advice?