Summary field works different once linked

[Filip Langenbick]

Hi,

I have a database for budget control

ID

Name_budget_line

Amount

 

Every budget_line has 3 titles

Ex:

Budget 1 - Subtotal

Expenses - Subtotal

Salaries - Subtotal

Salarie 1 - Amount

Salarie 2 - Amount

Salarie 3 - Amount

 

 

I create a subtotal (=Sum of Amount) and this works fine in every sub-summary part.

 

I made a extern file the same fields

ID

Name_budget_line

Amount

TOTAL=Sum of Amount

 

Linked the 2 tables but the TOTAL summery field doesn't work the same anymore.

It doesn't give me the totals per group but only for the last line.

 

Does anyone have any idea how to solve this.

 

Thanks a lot,

Filip

[mr_vodka]

If I am following, create a calc in your orig table that references the related table. Then do a sub summary on that break field. Breaking on a related field wont work that way.

[Lee Smith]

Hi Filip, and welcome to the Forums,

 

Automatic message

This topic has been moved from "Advanced & Developer Features" to "Calculation Engine (Define Fields)".

 

The Advanced & Developer Features topic is reserved for the discussion of the tools that that are part of the Advance and Developer Editions of FileMaker Pro Advance, and not for asking How-to questions.

 

Lee

[Filip Langenbick]

Thanks Lee,

 

@ mr vodka

not sure to understand, but i would love to evoid to make a new field in the original talbe

 

The original table has a budget

in the related tables are the real cost stored

 

i need to  compare those two tables

of course i could put everything in one table but that make it more complicated because i'm storing a least 10 years

 

Filip