If statement for text color expression

[akpofureenughwu]

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

[Anil_Babu_Samineni]

Is it possible to attach QVF file

[Muthu · Accepted solution]

Hi,

Try this expression.

if(count({$<[Project Status] = {'Completed'} >}Community)

/Count(Community)>=0.7,Yellow(),

if(count({$<[Project Status] = {'Completed'} >} Community)

/Count(Community)<0.69,LightGreen()))