title: How to group values in Calculated Field in DevExpress XtraReport Detail Band?
body: <p>I am attempting to move a report over from Crystal Reports to Repx and designing the report in DevExpress XtraReports.</p>
  <p>The existing Crystal Reports code is as follows:</p>
  <pre><code>if {Balance} = 0 then 0 
  else if IsNull({Series}) Then ({Balance} / Sum ({Balance}, {ID})*100) -- Grouped by ID on this line
  else ({Balance} / Sum ({Balance}, {Series})*100) -- Grouped by Series on this line
  </code></pre>
  <p>I have tried to mimic this code and move it in XtraReports and have as follows..</p>
  <pre><code>Iif([Balance] = 0, '0', 
  
  Iif(IsNull([Series]), (([Balance] / Sum([Balance])) * 100), 
  
  ([Balance] / Sum([Balance])) * 100)) -- As you can see on this and the above line I am missing the group 
                                       -- by &quot;ID&quot; and &quot;Series&quot; I don't believe the syntax exists in XtraReports. 
  
  </code></pre>
  <p>This is being complete in a detail band, so can't use the usual methods off adding a group header/footer etc.</p>
  <p>Is it possible to group like the Crystal Report example in XtraReports?</p>