Need help with filtered portal calculation

Discussion created by brianquillin on Sep 8, 2012

I am working with the following tables and TOs:

  • Budgets
  • Categories
  • Purchases
  • (among others)


On the Purchases layout (based on Purchases table) I have a portal referencing Categories 2. In this portal I want to show two things:

  1. Category Name (this is working)
  2. remaining budget balance for each budget category (ShowBudgets4::sBudget_amount - Purchases::sPurchases_amount)


*** This portal is to be filtered by the "current show" (this may be derived from any of the Show TOs seen in the attached graph) for which a budget has been prepared.


I have attempted MANY combinations of relationships and calculations with results ranging from NO data shown to from all purchases ever made.


WARNING: FileMaker Novice at Work Here... I am including a screen shot of that portion of my relational graph... please don't judge my rediculous attempts


Thanks in advance....


Screen Shot 2012-09-08 at 1.11.54 PM.png