SOLVED
Generate Combinations
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Musa_Musa
6 - Meteoroid
‎08-29-2023
04:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Alteryx Practice
4 REPLIES 4
MilindG
12 - Quasar
‎08-29-2023
04:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Musa_Musa Not sure about the formula but depends on the situation, heres one way you can do it.
‎08-29-2023
04:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you very much this is helpful!!
‎08-29-2023
05:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Something I forgot to mention, can each column have unique numbers that amounts to 85.
MilindG
12 - Quasar
‎08-29-2023
05:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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])'