Count Help Urgent...!!!

[#1]

Hi Friends

Please check this table mentioned below:

Batch Id	Assigned To	Date Assigned on	Reviewer Assigned	Status	Document Type
4992	Team 1	12-02-2013	Retwik Mukherjee	Completed	Out of Scope
4993	Team 1	12-02-2013	Hage Oni	Completed	Out of Scope
4994	Team 1	12-02-2013	Noshin Aarif	Completed	MSA  1992
4995	Team 1	12-02-2013	Sukanya Bhattacharyya	Completed	Amd to MSA
4996	Team 1	12-02-2013	Retwik Mukherjee	Completed	Amd to MSA
4997	Team 1	12-02-2013	Hage Oni	Completed	MSA  1992
4998	Team 1	12-02-2013	Noshin Aarif	Completed	Out of Scope
4999	Team 1	12-02-2013	Sukanya Bhattacharyya	Completed	Out of Scope
5000	Team 1	12-02-2013	Retwik Mukherjee	Completed	Novation Agreement
5001	Team 1	12-02-2013	Hage Oni	Completed	Out of Scope
5002	Team 1	12-02-2013	Noshin Aarif	Completed	Novation Agreement
5003	Team 1	12-02-2013	Sukanya Bhattacharyya	Completed	Amd to MSA
5004	Team 1	12-02-2013	Retwik Mukherjee	Completed	Amd to MSA
5005	Team 1	12-02-2013	Hage Oni	Completed	Out of Scope
5006	Team 1	12-02-2013	Noshin Aarif	Completed	Amd to MSA
5007	Team 1	12-02-2013	Sukanya Bhattacharyya	Completed	Out of Scope
5008	Team 1	12-02-2013	Retwik Mukherjee	Completed	Out of Scope
5009	Team 1	12-02-2013	Retwik Mukherjee	Completed	Out of Scope

I want to calculate count when status= Completed and  document type = Out of Scope w.r.t. to Team 1  

Please help me how to give the condition . I'm trying this condition count(if(status)='Completed' and if([document type])='Out of Scope')

but not getting any result....please help me out it's urgent...!!!

[#2 · Accepted solution]

Hi,

Try using this

count(if(status='Completed'  and [document type]='Out of Scope',BatchId))

Regards

Amay

[kaushiknsolanki]

Hi,

     Try this.

     Count({<Status = {"Completed"},Assigned_to = {"Team 1"},[Document Type] = {"Out of Scope"}>} Filed1)

Regards,

Kaushik Solanki

[#4]

Thanks Bro...!!!