IFERROR formula

BJSOON

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

=IFERROR(F3-F5,"-")

Reporting

Accepted answers

fmvizcaino

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.

Best,

Fernando V.

fmvizcaino

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.

All comments

fmvizcaino

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.

Best,

Fernando V.

BJSOON

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

=IFERROR(F3-F5,0)

fmvizcaino

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.

atcodedog05

Hi @AS

In the above scenario "NA" is a string and [Last order]-[First order] could be number which not same datatype. Both output should be same output.

Both columns are from "Date" datatype and it is only giving error in else part..in above near by "IsNull" this formula is working

atcodedog05

Hi @AS

You need to use DatetimeDiff() for subtracting between dates.

https://help.alteryx.com/20212/designer/datetime-functions

Hope this helps : )

Could not understand.. Have a look on shared image

Screenshot (102).png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703