1 2 Previous Next 19 Replies Latest reply on Jul 19, 2015 8:52 AM by beverly

    Indeterminate form of division

    electon

      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...

        1 2 Previous Next