unique_combinations_counter ( number_values )

This function calculates the number of unique combinations of n values (WARNING 212 Values Max)

Average rating: 4.5 (36 votes) Log in to vote

ericire - Show more from this author

Sample input:

unique_combinations_counter(4)
unique_combinations_counter(50)

Sample output:

15
1125899906842623

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

/* unique_combinations_counter (number_values)

by Eric Plassot


v.1, May 2009

    
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...)


NOT RECURSIVE

CUSTOMLIST function required

*/


Definir(
[
$n_val=number_values;
$n_combcum = "";
calc = CustomList (
 1;
 $n_val; 
"Let(
[
val = Combination ($n_val;[n]);
$n_combcum = $n_combcum+val
];
\"\"
)"
)
];
$n_combcum
)

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 ( number_values )

Comments

Support this website.

Support this website.