This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
Sure, below is what I'm expecting to happen, I just want to know how to get the Min of the 3 values (Column 6), but not the one with a 0 in it, and also have another column tell me the header of where the min came from; in this case it would be value 2 (Column 7). Right now when I drop a formula into the workflow and use the min function it will give me 0 from Value 3, instead of 4 from Value 2.
Source of Min
I was thinking something like a Multi Field Formula would work to change all the 0s to NULL and then just run the MIN formula right after would work, but I don't know how to change all the 0s to NULL values in Alteryx. Same goes for showing the source of the min value. I've done this in Excel, but I can't translate it to Alteryx.