DeveloperBarn
Is there an easier way to create a countif function?
This is a discussion on Is there an easier way to create a countif function? within the Visual Basic Programming forums, part of the Programming & Scripting category; I created a function that will determine whether an item should be counted based on the parameters entered. It returns ...
| |||||||
|
#1
August 7th, 2008, 06:26 PM
| ||||
| ||||
 Is there an easier way to create a countif function? I created a function that will determine whether an item should be counted based on the parameters entered. It returns a 1 if the criteria is met and a 0 if it is not. Basically it is similar to the COUNTIF in Excel, but requires an operator ( = > < <= >= <> ). It evaluates one set of criteria, because in Reporting Services, the functions are exectued once for each row in the result set. The main use for this is in reporting services which does not have a function like this. It is written in VB, and I am wondering if anyone can think of how this might be done more easily. Do any of you have a similar function? See code below: Code: Public Function CountIF(ByVal myExpression As Object, ByVal myOperator As Object, ByVal myCondition As Object) As Integer
Dim shouldCount As Boolean
Dim Count As Integer
Select Case myOperator
Case "="
shouldCount = (myExpression = myCondition)
Case "<"
shouldCount = (myExpression < myCondition)
Case "<="
shouldCount = (myExpression <= myCondition)
Case ">"
shouldCount = (myExpression > myCondition)
Case ">="
shouldCount = (myExpression >= myCondition)
Case "<>"
shouldCount = (myExpression <> myCondition)
End Select
If shouldCount = True Then
Count = 1
Else : Count = 0
End If
Return Count
End Function
=Code.CountIF(Fields!MyField.Value, "<>", 0)
__________________ "The Enrichment Center is required to remind you that first you will be baked, then there will be cake." - GLaDOS Last edited by Lauramc; August 7th, 2008 at 06:41 PM.  |
 |
|
| Bookmarks |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Create History Table / Outcome results | Rebelle | Database Design Help | 11 | June 10th, 2009 10:54 AM |
| Create ToolTip for GridView Header | jmurrayhead | .Net Code Samples | 0 | March 21st, 2008 02:26 PM |
| Create Virtual Directories in IIS | jmurrayhead | Microsoft IIS | 0 | March 21st, 2008 10:08 AM |
All times are GMT -4. The time now is 06:37 PM.
