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