Filter sales order by order total

@Crisel It might help to see more of the report and more of what you’re trying to capture. Not sure if you can just move the amounts into a grouping section and group by order number or you’ll need to make a variable and then total the variable instead?

This was the only topic I could find at the moment, but I’m sure I’ve seen others regarding getting a total using a variable if needed

Thanks so much for the reply. I am trying to modify the “Daily Sales Orders - Entered” and the values for these fields are “=sum([SOLine.CuryLineAmt]*-[SOLine.InvtMult])” but it doesn’t seem to be considering the surcharge and discounts. When I tried to use the inspect element I thought I could use the field Order Total which is =[SOOrder.CuryOrderTotal]. However when I tried to use the sum in the groupFooterSection it seems that it got the total of all the orders.  

I noticed there’s a filter set(as in screenshot below) but as I understand this filter should reflect in the groupFooterSection too and not get all orders’ total. 

Anyone else encountered odd behavior on using the SUM function in the report designer? Thanks in advance.

Hi @Crisel were you able to find a solution? Thank you!