Divide by 0 reported as Error with AMP and Multi-Field

Hey guys,

I've noticed that when AMP is turned on, the Multi-Field formula tool shows 'Divide by 0' as an error message rather than a warning

It does however still pass records through the tool.

Normal formula tools report Divide by 0 as a warning, and when AMP is turned off the tool reports it as a warning too

Is this expected behaviour? And if it is, can it be changed? I have workflows which are set to cancel on error and I wouldn't expect them to stop due to denominator zeros...

Ollie

divideby0.yxmd

Error Message

Bug

AMP Engine

Engine

AMP-Engine

Accepted answers

All comments

MarqueeCrew

@OllieClarke ,

IMO division by zero should be an error. I prefer to have an IIF() statement checking for zero and returning NULL() when the denominator is zero. This is better than having warnings.

i also respect that there are existing workflows that need to be refactored. There is an advisory statement that AMP should be tested on existing workflows prior to being turned on.

I'll tag @TonyaS for her visibility to your concern.

cheers,

Mark

alexnajm

Hi @OllieClarke,

That's very interesting - I've never seen that before! Maybe something to be submitted as a product improvement...

As a stop gap, you could have a Test tool or Message tool produce an error if the divide doesn't work (i.e. produces a null value) - that way the cancel on error still works!

-Alex

dYoast

This may be a stupid question, but why not eliminate both the errors and warnings by using an IF statement?

OllieClarke

@dYoast a combination of laziness and stubbornness

OllieClarke

@alexnajm thanks for the reply. In this case though I don't want the error from the divide by 0 to stop the workflow, so it's the other way round

alexnajm

@OllieClarke apologies for the misread!

harsh_alang

Hello @OllieClarke , thank you for bringing it to our attention. I personally value consistent behavior and I will approach this as a defect and add to our bucket.

OllieClarke

Thanks @harsh_alang

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703