3 Replies Latest reply on Oct 25, 2018 6:14 AM by Ombir Rathee

    'Null' is displayed while using 'IF ' condition for Coloring field based on count

    Sunitha Nagalapur

      IF NOT ISNULL([Population Out Records Today]) AND NOT ISNULL([Unit Population Records Today])

      THEN

          IF    

          [Population Out Records Today]>[Population Out Records Yesterday] AND  

          [Unit Population Records Today]> [Unit Population Records Yesterday]THEN "Green"

          ELSEIF

          [Population Out Records Today]=[Population Out Records Yesterday] OR  

          [Unit Population Records Today]=[Unit Population Records Yesterday] THEN "Yellow"

          ELSEIF

          [Population Out Records Today]<[Population Out Records Yesterday] OR 

          [Unit Population Records Today]<[Unit Population Records Yesterday] THEN "Red"

          END

      ELSE

          "Red"

      END

       

       

      i'm getting Null and Red though count of those fields are equal..