Generate Combinations

[Musa_Musa]

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

[MilindG · Accepted solution]

@Musa_Musa Not sure about the formula but depends on the situation, heres one way you can do it.

[Musa_Musa]

Thank you very much this is helpful!!

[Musa_Musa]

Something I forgot to mention, can each column have unique numbers that amounts to 85. 

[MilindG]

@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])'