Summary for Portals

[fraGiacondo]

hi

i have some questions to portals and how to make summaries.

just a short description to what i´m working on.

i´m an architect and i´m trying to integrate FM to my workflow.

in this case I have an apartment building with 150 apartmnents.

with my drawing program i´m generating a table for all rooms in the apartment building.

i have a table with different informations (Fields) to rooms like ,RoomNr, Floor,Size, RoomHeight.....etc

i made an other table to get different summaries of the apartments.

i make a layout and place 3 portals. each of them are filtered and sorted to get the right rooms i need.

my problem is i would like to have the summary field that show the total of the each sorted portal.

is this possible to do it with the portals in one layout?

all the summaries i get are always the total of all Rooms in the apartment, but not the summaries of the portals.

the only way i get the right sum if i place the summery field in the portal itself, but then i get this information in every row of the portal (this is not the way i want).

its something like this:(i´m looking for the red lines)

Portal1:

APP1 ROOM1 2,00m²

APP1 ROOM2 4,00m²

APP1 ROOM3 6,00m²

SUM1:12,00m²

Portal2:

APP1 ROOM4 2,00m²

APP1 ROOM5 4,00m²

SUM2:6,00m²

Portal3:

APP1 ROOM6 10,00m²

SUM3:10,00m²

may be somebody could help me

regards

f.

[efen]

I'm not sure why you need/what is the table of summaries?

You need three calculation fields in the table on which your layout is based - one for each portal.

Portal 1 calculation will be like: Sum(portal1relatedrecords::numberfield)

Portal 2 calculation will be like: Sum(portal2relatedrecords::numberfield)

Portal 3 calculation will be like: Sum(portal3relatedrecords::numberfield)

[fraGiacondo]

Hi efen

Thank you for your reply!

I was looking for something like this.

I tried your suggestion, but i always get an error "can not find Table"

my problem i can not address the portal. ;-(

the table of summaries,

because there are a lot of different summaries i have to calculate, not just for the single apartments

also for a lot of combinations and to calculate with this different summaries, i decided to make a separate table to store all the summary values.

f.

[efen]

How are your tables related to one another? Is the summary table the one on which you are showing these portals?

It may help if you post a diagram of the relationships in your file or a copy [simplified if necessary] of your file (with a few dummy records).

[fraGiacondo]

yes the portals are made in the layout of the summary table.

"basically there are no Real relations to the tables"

but the relations are two fields BUILDING and APARTMENT (Two Fields in The ROOMS TABLE) are the same in SUMMARY TABLE

this Fields are Valuelists in the "Summary Table" referring to the "Rooms Table"

this is filtering the Single Appartments in the Portals

maybe it will go this way, al the data is made in german so i think this will be little bit confusing