Create a summary field on fields of an external table

[Filip Langenbick]

Hello,

 

does anyone know how to create a summary field (sum in my case) of a field in an external table (budget cost in my case).

 

i tried to create the summary field in the external table, but it won't work in the original table

 

does anyone has any idea??

 

thank a lot,

 

Filip

[Aussie John]

You will have to use the getsummary calculation

[Filip Langenbick]

You will have to use the getsummary calculation

Thanks John, I already tried it, but no success.

Actually I would like to avoid creating new fields in the original table.

 

The original talble is the actual budget

The external tables are:

1// Actual cost per month of the same year of the budget

2// Actual cost of the previous years

 

Thanks,

Filip

[Rick Whitelaw]

Maybe just use the Sum function as a field in the parent table. This will, however, necessitate creating a new field in the parent table. There reallybisn't any reason I can think of to not do this.