AnsweredAssumed Answered

Custom function for calculating mode?

Question asked by rmulder on Sep 20, 2013
Latest reply on Sep 22, 2013 by rmulder

Title

Custom function for calculating mode?

Post

     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?

     Many thanks!

Outcomes