title: How to exclude one value from a grouping sum, based on a value of another field?
body: <p>How do I exclude one value from a grouping sum, based on a value of another field?</p>
  
  <p>ie  I open Report=> Report Properties=>Code and insert my Custom Code, but how would I change the below code to exclude a numeric value of another field for the below case?</p>
  
  <pre><code>Public Function ChangeWord(ByVal s As String) As String
     Dim strBuilder As New System.Text.StringBuilder(s)
     If s.Contains("Others") Then
        strBuilder.Replace("Others", "Other NOT INCL")
        Return strBuilder.ToString()
        Else : Return s
     End If
  End Function
  </code></pre>