electon

Indeterminate form of division

Discussion created by electon on Jul 18, 2015
Latest reply on Jul 19, 2015 by beverly

Just came across a rather peculiar thing in a calculation field.

 

While trying to calculate an average value based on two fields, all both number fields:

Let's call it average = total / qty.

 

When both fields have a value of zero the calculation result is ?. Yes, a question mark.

 

From what I could find it's called in mathematics an "indeterminate form of division"

I was rather expecting ( hoping for ) a zero .

 

I'm sure somebody already knows about this behaviour,

But it's a trap for young players, like myself. Especially if you count on that number to use somewhere else.

So why not get it out in the open...

Outcomes