Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

IFERROR formula

Highlighted
8 - Asteroid

Hi how do I convert this Excel formula in Alteryx?  Thank you. 

 

=IFERROR(F3-F5,"-")

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @BJSOON ,

 

You can use 

if IsNull([F3]-[F5])
then '-'
else [F3]-[F5]
endif

 

The only problem here is that you will need to leave the data type as string.

fmvizcaino_0-1582884180774.png

 

Best,

Fernando V.

 

Highlighted
8 - Asteroid

Thank you!   If I change it from "-" to 0, can I leave the data type as V_WString?

 

 

=IFERROR(F3-F5,0)

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

If you change the iferror result, you can use as text or numeric.

if IsNull([F3]-[F5])
then 0
else [F3]-[F5]
endif

 

best,

Fernando V.

Highlighted
8 - Asteroid

Thank you!

Labels