Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...!!!
Hi,
Try using this
count(if(status='Completed' and [document type]='Out of Scope',BatchId))
Regards
Amay
Hi,
Try using this
count(if(status='Completed' and [document type]='Out of Scope',BatchId))
Regards
Amay
Hi,
Try this.
Count({<Status = {"Completed"},Assigned_to = {"Team 1"},[Document Type] = {"Out of Scope"}>} Filed1)
Regards,
Kaushik Solanki
Thanks Bro...!!!