title: Acumatica: Custom Subtotal with an Non-Stock Item
body: <p>Very new to acumatica so don't have the terms down completely, so gentle. My issue is with the syntax for the report designer. I have a client that wants to add in a temporary fix to setup a non-stock item to have a separate item total. I need to pull it out of the row and add it to my text field. I have a check for the Item's description to get the Current Unit Price in that line.</p>
  
  <p>In my groupFooterSection1</p>
  
  <p><code>=Round(([ARInvoice.FreightTot]) + (iif([ARTran.TranDesc] = 'my non-stock item', 
  CDec([ARTran.CuryUnitPrice]), CDec(0))), 2)
  </code></p>
  
  <p>I was looking to do something like <code>ARTran[2].TranDesc</code> but that didn't work for this situation. The issue from my snipper is I'm getting only the first item in the group and not the rest. If I switch around the if statement it will do the last one. However I don't know if the non-stock item will be the last or the first one in the group so that won't do.</p>