Link a monthly budget to a table based on single invoice lines

[#1]

Good morning Community.

I need to link a table based on singel invoice lines to a table comtaining a monthly budget.

See the data model:

I can create 2 separate tables 1 = turnover and calculations and 2 = budget, but I can not show the budget on top level in the table turnover(Umsatz), the result is always '0'.

The formula I use is

I have tried to use the join and concatinate function in the load script to link the budget table to the ttunover table but both deliver the funny synkeys.

See Script attached:

Help would be appriciated. Thanks Matthias

[marcus_sommer]

Have a look here: Re: Linking tables in Data Model

- Marcus

German User Group - Deutsche User Group

[#3]

Thanks Marcus, need to test this.