Sum Ext Price Dtl by customer for current month only

[kenm (Ken Marchand)]

I have made several attempts with no luck. I am trying to create a simple BAQ that will sum month to date Ext Price Dtl by customer. I have also researched on several sites and have not found a solution. Would appreciate any help on this. Thank you!

[Jason_Woods]

Filter the table by the BAQ constant FirstDayOfCurrentMonth. Group by all non-summary fields and add a calculated field for
SUM(OrderDtl.ExtPriceDtl)

[Banderson (Brandon Anderson)]

If you don’t want them grouped, look up windowing functions. Something like this.

Sum(price) over (partition by customer, month order by date asc)

My syntax is probably not right, as I’m typing on my phone right now, but that should get you your running sum by customer and month.

Sum summary

Hi all, Is it possible to add a column that displays the overall sum value? On the BAQ i have, i am able to add the sum line by line using this calculated field “sumhidden”: sum(hide) over (partition by PartDtl.PartNum order by PartDtl.DueDate rows between unbounded preceding and current row) I dont want this, i want each line to display the final value from the summary sum e.g. Sum for “counthidden”. Any help would be much appreciated. Many thanks hymal7 [image]

[kenm (Ken Marchand)]

Jason,
I greatly apologize for my delay but want to thank you for your suggestion. This makes sense and will give it a try. I would prefer not to group but I am confident this will work fine. Thank you again, greatly appreciate your time.
Thanks
Ken

[kenm (Ken Marchand)]

Brandon,
I apologize for my delay in replying. This solution makes sense and I will give it a try. Thank you for your time, it is greatly appreciated.
Thanks
Ken