Mode ( ValueList ; Value ; Cnt )

Returns the mode of the return separated values in ValueList

Average rating: 4.2 (28 votes) Log in to vote

Phil Caulkins (aka PhilModJunk)
Caulkins Consulting
http://don't have a web site.com

Sample input:

Mode ( List ( 2 ; 3 ; 4; 3 ) ; "" ; "" )

Sample output:

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

// Mode ( ValueList ; Value; Cnt )
//
// valueList    :  A return separated list of values. values can be text or number
// value         : Iterim value that passes the current mode candidate to the next recursive call of the function.
// Cnt            : The count of the items of the currently nominated value
//
Let ( c = ValueCount ( FilterValues ( ValueList ; GetValue ( valueLIst ; 1 ) ) ) ;
          Case ( IsEmpty ( ValueList ) ; Value ; // return current data in Value if list is empty
                    c > Cnt ; Mode ( RightValues ( ValueList ; ValueCount ( ValueList ) - 1 ) ; GetValue ( ValueList ; 1 ) ; c ) ;
                    Mode ( RightValues ( ValueList ; ValueCount ( ValueList ) - 1 ) ; Value ; Cnt )
                   ) // case
      ) // let

Returns the most frequently occurring value in a return separated list of values.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Mode ( ValueList ; Value ; Cnt )

Comments

Support this website.

Support this website.