Hi @brendan91 ! Are you grouping these results or displaying all the lines?

There won’t be a way to SUM all the lines unless it’s grouped I suspect, unless you create a SQL view which already SUMS these, then this could be displayed instead of a calculation.

But your calculation should work based on the way it looks.

I did a quick mock up using SOOrder and Order Type and found it looks exactly like you’re showing:

=IIF(pSOOrder.OrderType]= 'CS' OR CSOOrder.OrderType]='IN', CStr(,SOOrder.CuryOrderTotal]), '')

Again though, if you are wanting a summary of these amounts you’ll need to group by the Order Nbr or Inventory ID maybe

@BenjaminCrisman I think I was trying it easier for an excel export, or was hoping I could figure out how to summarize this in report designer. The issue I was having with getting this formula to work was around data types and I just figured it out.

I was having a bad day when I wrote this apparently. Thanks!