title: SSRS expression explanation in group list?
body: <p>I'm working on SSRS reporting , we have one report in that group section is there and for 
  one value named <code>Long-Only</code> some expression is there as follows</p>
  
  <p><code>=IIF(CDec(Parameters!NAV.Value) &gt; 1,((SUM(Fields!LongMV.Value) - SUM(IIF(Right(Fields!SecurityType.Value, 4) = "Cash" OR Left(Fields!SecurityType.Value, 8) = "Treasury", Fields!LongMV.Value, 0)))/(Parameters!NAV.Value/1000)) -1,0)</code></p>
  
  <p>Here above expression is a calculation for <code>LONGVALUE</code></p>
  
  <p>I want to execute this function is there any way to do so (only this function by putting sample values)?</p>
  
  <p>NAV.Value = 1200
  SUM(Fields!LongMV.Value) = 49</p>
  
  <p>what this does <code>(Right(Fields!SecurityType.Value, 4) = "Cash"</code>?</p>
  
  <p>I'm new to ssrs reporting could anyone please help me to know the expression.</p>
  
  <p>we are using stored procedures for reporting.</p>
  
  <p>thanks</p>