2 Replies Latest reply on Apr 2, 2014 6:55 AM by Matt Lutton

    very simple calculated field results in null

    Max Elliott

      I have two columns. Both are integer valued. I create a calculated field like:

       

      [FieldOne]/[FieldTwo]

       

      And I get results of null across the board. Not a single value is anything but null. I have checked the data, and there are no nulls in it. There are some values of zero in FieldTwo, so I changed my formula to read:

       

      IF (FieldTwo > 0) THEN (FieldOne/FieldTwo) ELSE 0 END

       

      To no avail. Still results in all nulls. What am I doing wrong?

       

      (p.s. I have also tried converting the fields to FLOAT and still no luck)

      -Max