Relationship Summary filtered by current record

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Purchase Orders can have many line items and many projects.  I would like to create a summary report that totals the Purchase Order line items of the current Project only.  PO 1=$500 however it is divided between 2 projects.  When I view Project A, I would like to Line item to total $200 based on a filter of "current project" (Project A in this case).  Is this possible?

i.e.: 

Project A

PO 1- Material 200

Project B

PO 1-Labor 300

Photo of Christine

Christine

  • 352 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Mira Shnier

Mira Shnier

  • 0 Points
Can you tell us what is the definition is of the "Current Project".  

Also is the structure that not only does 1 PO have many PO lines but also 1 Project has many PO lines?
Photo of Christine

Christine

  • 352 Points 250 badge 2x thumb
When in the Project table, it would be the current record

Project #ID 1 (Project A)

PO Summary (with filter Project=Project #ID 1)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,320 Points 50k badge 2x thumb
Sorry, but that does not help me to help you.  You are saying that 1 Project has many PO Lines and you only want to see totals for the "Current Project".  or is what you are saying is that you want to be able to go to the project record and see ITS PO Lines totals up or in detail - is that what you are asking?
Photo of Christine

Christine

  • 352 Points 250 badge 2x thumb
I figured it out, thank you!