Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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()))
Is it possible to attach QVF file
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()))