SOLVED
How to use 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
akanksha01
6 - Meteoroid
‎04-06-2017
08:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
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 I am expecting to produce.
Please suggest.
Thanks
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
2 REPLIES 2
alex
11 - Bolide
‎04-06-2017
09:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎04-07-2017
09:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Alex.
I tried your way and applied CountNullNonDistint instead since I wanted three different results (No, Yes and No Data), and along with this used "IF c THEN t ELSEIF c2 THEN t2 ELSE f ENDIF" in Multi Field Formula for Null, 0 and 1 key, and that worked perfectly.
Thanks again.
