SOLVED
If statement with Sumifs in Alteryx?
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
moinshaik
7 - Meteor
‎09-25-2019
12:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need to create a workflow which can replicate nested IF function with Sumifs function used in excel. I am new to Alteryx and juggling between different tools but unable to produce desired output.
I have attached input file which has dataset along with the output (Column I is the output required in alteryx) I am expecting to produce. Column A to H is an Input.
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
- Data Investigation
2 REPLIES 2
Dazzerman
11 - Bolide
‎09-25-2019
02:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎09-25-2019
03:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much for the solution. It worked.
