6 Replies Latest reply on Nov 20, 2018 1:24 AM by Sunitha Nagalapur

    Issue with Conditional color formatting

    Sunitha Nagalapur

      Hi All,

       

      I'm trying to color the Status in dashboard using  below mentioned if condition as explained in screenshot based on number of records in tables.

       

       

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

      THEN

          IF

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

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

          [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

          "Blue"

      END

       

      number of records as of now is mentioned below and as per the condition i should be getting 'Red' as result but i'm always  having 'Blue' printed please suggest to fix issue.

      Thanks..