Set analysis

[smilingjohn]

HI All ,

Iam trying to include the below expression into set analysis but its not executing

Can the expertise please help me ..

count(if(IsNull(Closed), Resolved,Closed)   This expression needs to be included in the below set analysis...

This says count of closed in if closed are null the count Resolved ...now the requirement is to pass certain fields ..therefore iam trying the below expression .

=if(if(count({<Class={'Class 1','Class 2'},Dys={"=Days >=0 and Days <=7"}>} isnull(Closed),Resolved,Closed)<>0,Green(),Red()))

Thanks in advance

[devarasu07]

Hi,

you can try like this.

=if(

     count({<Class={'Class 1','Class 2'},Dys={"=Days >=0"}>}

          if( isnull(Closed),Resolved,Closed)

     )  *      count({<Class={'Class 1','Class 2'},Dys={"= Days <=7"}>}

          if( isnull(Closed),Resolved,Closed)

     )

     <>0,Green(),Red()

)

[andrei_delta]

It was incorrect and now is correct ? How come?