Skip to main content

Hi, I am trying to get the total of the sales order (together with all the charges/discounts) I tried using the field SOOrder.CuryOrderTotal] but when I tried to get the sum, it seems that it is getting the sum of all the line items. Do I filter them and how?

Thanks so much in advance!

@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

@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(lSOLine.CuryLineAmt]*-eSOLine.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 =dSOOrder.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.

Reply


Terms & ConditionsCookie settings