Good day
I need help creating a formula in Alteryx that generates all possible combinations of numbers that add up to 85 using a list of numbers from 1 to 30. "Something like this (A+B+C=85)"
Solved! Go to Solution.
@Musa_Musa Not sure about the formula but depends on the situation, heres one way you can do it.
Thank you very much this is helpful!!
Something I forgot to mention, can each column have unique numbers that amounts to 85.
@Musa_Musa You can add below filter and see if that gives you the result you're looking for.
'([No 1] != [No 2]) and ([No 2] != [No 3]) and ([No 1] != [No 3])'