Hi Dan,
Thanks for sharing your BAQ; it’s very close to what we were looking to create and should save us a ton of time recreating the wheel.
I have one question with regard to the Parent Rev number. I am fairly green when it comes to subqueries and understanding what to change on which level to get the correct results. The Parent Rev column shows multiple revisions and I’m trying to limit it to be the latest or max revision.
Do you know which subquery that would need to be done in so that costs for only one rev (the latest one) populate?