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

[swuehl · Accepted solution]

Not really sure, but maybe

=if(

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

          if( isnull(Closed),Resolved,Closed)

     )

     <>0,Green(),Red()

)

[Chanty4u]

try this

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

[smilingjohn]

Hi CHanty this is giving the error

[Chanty4u]

waht error your getting?

[smilingjohn]

Error in epression , a red mark after closed <>0

[smilingjohn]

it says error in expression

[Chanty4u]

can you share the screen shot of it?

[Anil_Babu_Samineni]

Try this first alone and check how it returns?

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

[andrei_delta]

Hello,

you misspelled the field Days.

From your code: Dys={"=Days >=0 and Days <=7"}>}

Hope it helped,

Andrei