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
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()
)
It was incorrect and now is correct ? How come?