help required in set expression

[sayadutt]

Hi Team,

I have an expression like below:

if(count({$<[Test Cases  ]={'In Progress', 'Completed'}>} [Project Name  ])/count({$<[Test Cases  ]=>} [Project Name  ])=1, green(), red())

Above expression counts the number of In Progress and Completed test cases out of TOTAL test cases and determine Green or Red.

Now I need to modify the above expression and instead of only In Progress and Completed ones I need to consider ALL where length is greater than 1.

can you please modify my current expression...(orange part) and replace that with len([Test Cases  ]) > 1.

(in short I am trying to ignore the blank values but it does not show up in null() function ). So they are not really null but can be ignored if we consider length greater than 1.

Thanks

[robert_mika · Accepted solution]

Try

if(count({$<[Test Cases  ]={"=Len(Test Cases ) > 1"}>} [Project Name  ])/count({$<[Test Cases  ]=>} [Project Name  ])=1, green(), red())

[sunny_talwar]

Length of Test Cases in days? Are you calculating the length somewhere in your script? Or do you have start and end date?

[PrashantSangle]

Hi,

Try like

if(count(if(not isnull([Test Cases]) or len(trim([Test Cases]))>0,[Project Name ] )

/

count({$<[Test Cases  ]=>} [Project Name  ])=1, green(), red())

Regards

[sunny_talwar]

I guess I was thinking about incorrectly. I thought we were looking at length in time , wherein he might be looking for length of the field itself.