8 Replies Latest reply on Sep 21, 2017 1:32 AM by Mahi Jain

    IF NULL THEN ZERO CALCULATION

    Diogo Braga

      I have the following calculated field:

       

      IF [Open Seats]>=0 THEN [Open Seats] END

       

      When Open Seats IS NOT greater or equal to zero it's returning NULL, but I need it to return 0. How Can I do that?

       

      I tried the following, although valid, still shows NULL.

       

      IF [Open Seats]>=0 THEN IFNULL([Open Seats],0) END