BAQ Calculated Sum based upon "From" & "To" parameters

Kinetic ERP
1

Hello,

I know how to do BAQs as an Operations person rather than as a coder. Using BAQ Designer.

Table PartTran

I am trying to get transactions between a From and To date using parameters. However, the sum always returns the total value for all transactions rather than the date range in the parameters. What am I missing?

I believe I need to add to the calculated field the TranDate and have it pull from the Parameters, but I don’t know how to write this. My calculated field is just: sum(PartTran.TranQty)

image
image2454×584 55.2 KB

2

Please disregard this question.

The key is to set subquery criteria using the from and to parameter. I knew this when I originally did it 4 years ago, but spent a half hour digging through all the junk in my memory. :wink:

1 Like
3

You need to add criteria to restrict the results by you parameters:

image
image1018×549 17.2 KB