Error dividing by 0 - how to remove error message

[Meiye]

Hi all, 

When I run the workflow it produces error messages when for dividing by 0 (amount exceeding error message limit), but it outputs everything normally and doesn't effect anything else. But I would like to have it not show an error after running, because then I might miss an actual error if it occurs. Is there a way to do that for one specific tool?

Thanks,

Meiye

[Aryasuta_Panda]

Hi, you can replace the '0' occurrence by null so that instead of the error you will get null values which will not impact the result I guess. 

Thanks.

[geraldo]

@Aryasuta_Panda 

Na fórmula que você está realizando a divisão, faça primeiro um teste:
if [divisor] == 0 then 0 /* or  equal Null()*/
else [dividendo] / [divisor]
endif

A mensagem é controlada aqui.

[danilang]

Hi @Meiye 

Adding to @geraldo's suggestion, I would recommend using the Null() option as opposed to 0.  A result of 0 naturally occurs if the numerator is 0, so setting the result of a divide by 0 to 0 will give you false positives.  Using null() allows you to differentiate the divide by 0 transactions if required.  It's too bad Alteryx didn't implement the Inf and NaN values found in R.

Dan