Greetings, I am looking for comments regarding this usage of Aggr. This expression is being used with QuickBooks Advanced Reporting. The goal is to list open sales orders. I am unable to modify the load script.
The sales order, [Transactions.Ref Number], has both header and line level records. If the header record fields, [Transactions.Fully Invoiced] or [Transactions.Manually Closed] =0, then sum [Transactions.Amount] for the [Transactions.Ref Number] when the line is not [Transactions.Manually Closed].
This expression is working, but I am not confident this is a proper usage of Aggr.