Divide By Zero Error | IFERROR Function

clucky

How does one get around this error that occurs from this error? I replicated the logic in excel into Alteryex, but there are zeros or smaller denominators which are producing a "null" result. Is there a remedy to this?

=IFERROR(1-$AX33/$AU33,0)

=IFERROR(1-$V23/$T23,0

Question 2: 

=$BB63*IFERROR($V63/$T63,1) which is providing "exponent notation" in the results. How to remedy this?

BrandonB

You can use a data cleansing tool right after your formula where you replace nulls with zeros, or you can use a formula right after your initial formula and say 

IIF(IsNull([Field you created),0,[Field you created])

To answer your second question, you probably want to set the data type of your formula (down at the bottom of the formula) to double rather than VW String, or a fixed decimal if you want it rounded to a certain decimal place.