Error in Expression

[#1]

Hi

Could some one rectify this expression , it is not executing.

=Count(if([P ID]='1',([Review Name]='ECO1' , [Review Decision]<>'Pass') and

if([P ID]='2',([Review Name]='ECO2', [Review Decision]<>'Pass'),PRJ_ID)))

need to count PRJ_ID based on theses conditions  [P ID]='1',([Review Name]='ECO1' , [Review Decision]<>'Pass'

Thanks

[tamilarasu]

Hi Vamsi,

Try this,

=Count({<[P ID]={'1','2'},[Review Name]={'ECO1','ECO2'} , [Review Decision]=-{'Pass'}>} PRJ_ID)

[Anonymous]

HI

Try this

• =Count({<PID={'1'},ReviewDecision-={'PASS'},ReviewNAme={'EC01'}>}PRJ_ID)

[#4]

Try this below Set analysis Expression  I hope this will works..

=Count({<[P ID]={'1'},[Review Name]={'ECO1'},notMatch([Review Decision],'Pass')>}PRJ_ID)

[Kushal_Chawda]

try

=Count({<[P ID]={'1'},[Review Name]={'ECO1'} , [Review Decision] - ={'Pass'}> * <[P ID]={'2'},[Review Name]={'ECO2'} , [Review Decision] - ={'Pass'}>} PRJ_ID)

[jonathandienst · Accepted solution]

Kush141087:

=Count({<[P ID]={'1'},[Review Name]={'ECO1'} , [Review Decision] - ={'Pass'}> * <[P ID]={'2'},[Review Name]={'ECO2'} , [Review Decision] - ={'Pass'}>} PRJ_ID)

I agree, except that you need a union rather than an intersection:

=Count({<[P ID]={'1'},[Review Name]={'ECO1'} , [Review Decision] -={'Pass'}> + <[P ID]={'2'},[Review Name]={'ECO2'} , [Review Decision] -={'Pass'}>} PRJ_ID)

(and no spaces between the - and = for the -= operator)

[#7]

Thankyou Jonathan