BAQ Challenge - How to convert this SQL with sub-selects (as Calc'd fields and where clauses) to a BAQ

knash · February 25, 2019, 3:29pm

This super close to your query.

Yes it is slow
Yes there are better ways to do this
But it works. lol

Differences:
TranDate to be the last three months from today vs the date field you have.
Company Filter on the main, which you can add quickly.