title: SSRS Total Count calculation if value is less than threshold
body: <p>I have a very unique question &amp; i have read countless topics on it, not found a correct answer.
  Please help me in this.</p>
  
  <ol>
  <li><p>I have a matrix where i'm calculating the count of all Satisfied, Very safistied, neither satisfied nor unsatisfied or very unsatisfied or unsatisfied. 
  Even if the count value is less than 5 i'm using below code to hide the count of 5  . </p>
  
  <p>=(Switch(Count(Fields!Q27_A_1.Value)&lt;5, "*",
   Count(Fields!Q27_A_1.Value)>5 , Count(Fields!Q27_A_1.Value)))</p></li>
  </ol>
  
  <p>And i need to count the total of this cell into another cell in row and show their value </p>
  
  <pre><code>But if it contains any "*" values 
  then total will be "*" 
  else display = Count(Fields!Q27_A_1.Value).
  </code></pre>
  
  <p>I have writtten these lines of custom code but not working. :
  Getting Error : Input String was not in correct format </p>
  
  <pre><code>Public Function SafeConvert(ByVal num As String) As String
  
  Dim s as String
  IF IsNumeric(num) &lt;5 
  Then
  Return "*"
  Else :
  For i as integer = 0 to 4
  s += num
  Next 
  Return s
  End IF
  
  End Function
  </code></pre>
  
  <p>At the end, I'm calling this function into that cell using</p>
  
  <pre><code>=Code.SafeConvert(ReportItems!Textbox4.Value)
  </code></pre>