unique_combinations_counter_rec ( number_values )

Same as "unique_combinations_counter (number_values)"; but recursive. This function calculates the number of unique combinations of n values (WARNING 212 Values Max)

Average rating: 4.3 (35 votes) Log in to vote

ericire - Show more from this author

Sample input:

unique_combinations_counter_rec(4)
unique_combinations_counter_rec(50)

Sample output:

15
1125899906842623

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

/* unique_combinations_counter_rec (number_values)

by Eric Plassot


v.1, May 2009

Same as "unique_combinations_counter (number_values)"; but recursive.   
This function calculates the number of unique combinations of n values (WARNING 212 Values Max)
ex : 
list = "a¶b¶c¶d" ----> 4 values
combinations = "a¶b¶c¶d¶ab¶ac¶ad¶bc¶bd¶cd¶abc¶abd¶acd¶bcd¶abcd"
---> 15 unique values (without aa, abc=bca=cab=acb...)


RECURSIVE*/

if(
    number_values  > 212;
    "error (number_values>212)";
    Case(
        $Counter < number_values;
        let(
            [
                $n_combcum = Cas( $Counter = ""; ""; $n_combcum );
                $Counter = $Counter + 1;
                $val = Combination( number_values; $Counter );
                $n_combcum = $n_combcum + $val
            ];
            unique_combinations_counter_rec( number_values )
            );
        let( $Counter = ""; $n_combcum )
         )
  )

Same as "unique_combinations_counter (number_values)"; but recursive.
This function calculates the number of unique combinations of n values (WARNING 212 Values Max)
ex :
list = "a¶b¶c¶d" ----> 4 values
combinations = "a¶b¶c¶d¶ab¶ac¶ad¶bc¶bd¶cd¶abc¶abd¶acd¶bcd¶abcd"
---> 15 unique values (without aa, abc=bca=cab=acb...)

Comments

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

unique_combinations_counter_rec ( number_values )

Comments

Support this website.

Support this website.