2 Replies Latest reply: Apr 11, 2017 1:33 AM by Muthu Kumar RSS

    If statement for text color expression

    Akpofure Enughwure
    Akpofure Enughwure Apr 11, 2017 12:43 AM

      Good day everyone..

       

      I'm using this expression

      if((count({$<[Project Status] = {'Completed'} >} Community )/ (Count(Community))))>=0.7,yellow(),if((count({$<[Project Status] = {'Completed'} >} Community )/ (Count(Community))))<=0.69,lightgreen())))..... This is for the PRogress indicator... see attached...

       

      I'm getting error in expression...

      I tried bugging it but to no avail..

       

      Please help.

       

      Regards