AnsweredAssumed Answered

Calculation using summary fields from different tables

Question asked by BorisKamp on Jan 7, 2015
Latest reply on Jan 9, 2015 by BorisKamp

Title

Calculation using summary fields from different tables

Post

Hi!

I have two tables:

         
  1. Monthly Financials
  2.      
  3. 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?

 

Outcomes