@IFERROR Formula in Alteryx

[Virgie0113]

Hi,

I am trying to do a workflow to convert my excel spreadsheet below to Alteryx workflow. I was able to recreate Col A-L right now.  

I am not sure on how will I do an @IFERROR in Alteryx so I can do column M,N and O.  

Thank you in Advance!

[AngelosPachis]

Hi @Virgie0113 ,

Try having a look at the following two posts. Maybe one of them answers your question?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/IFERROR-formula/td-p/534725

https://community.alteryx.com/t5/Dev-Space/ifError-formula-simplified/td-p/797768

Cheers,

Angelos

[PangHC]

try switch function. 
Conditional Functions | Alteryx Help

[Virgie0113]

This is the excel formula I am trying to do in Alteryx

 =@IFERROR(IFS($I4="BBE",$H4,$I4="BBC","",$I4="Mixed",$H4*K4),"")

[mceleavey]

Hi @Virgie0113 ,

If you could post the spreadsheet rather than a picture, and let us know what you're trying to do we will be able to help.

M.

[Virgie0113]

Hi,

Attached is the excel spreadsheet I am trying to convert to Alteryx.  I I was able to figure out Col A-L.

I am trying to figure out how to convert the formulas in column M,N and O in Alteryx. =@IFERROR(IFS($I157="BBC",$H157,$I157="BBE","",$I157="Mixed",$H157*J157),"")

Thanks!

[mceleavey · Accepted solution]

Hi @Virgie0113 ,

These are simply nested if functions.

I've built the calculations for you in the attached workflow:

I hope this helps,

M.

[Virgie0113]

Thank you! this is really helpful!