Calculation using summary fields from different tables
I have two tables:
- Monthly Financials
- Property taxes
Both have a summary field that with a total of the amounts (Monthly Financials::Total NOI & Property Taxes::Total)
Both tables are displayed in a bigger picture with portals next to each other, so both summary fields are on the same layout as well.
Now I need another field on this layout that will do this 'Monthly Financials::Total NOI - Property Taxes::Total'
In other words, substract the total of taxes (one table) from the total of income (other table).
But I can't seem do do that! it gives me wrong weird numbers I can't trackback at all the whole time! what am I missing?