Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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()
)
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()
)
try this
=if(if(count({<Class={'Class 1','Class 2'},Closed={' '},Dys={"=Days >=0 and Days <=7"}>} Resolved,Closed)<>0,Green(),Red()))
Hi CHanty this is giving the error
waht error your getting?
Error in epression , a red mark after closed <>0
it says error in expression
can you share the screen shot of it?
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())
Hello,
you misspelled the field Days.
From your code: Dys={"=Days >=0 and Days <=7"}>}
Hope it helped,
Andrei