I made a dashboard from a BAQ, which has a calculated field that takes the total ship qty of parts for certain customers in a date range. The dashboard itself works fine, but I want to add a field that calculates all the baqview.Calculated_TotalShipQty rows together into view2.TotalQty.
I thought the calculation widget would work, but it only adds the first row of the baq to view2.TotalQty. What I did in the calculation widget was just add one parameter and operation to add baqview.Calculated_TotalShipQty to view2.TotalQty. I tried the same thing with Row-Update, but that gets the same result.
What I was thinking was having some sort of loop that takes just keeps adding the baqview rows to TotalQty until there are no more rows, but I am unsure of how I should go about that in application studio.
