Add portal that sums totals for years

[deego55]

Hi All. I have a portal with several fields, all based on a year. There can be multiple portal rows for any given year. i would like to add another portal on the same layout that will show the sum of a couple of the fields for every year in the first portal. for instance it would look like this:

portal 1

2005 | 200 | 100

2005 | 100 | 100

2006 | 50 | 100

Portal 2

2005 | 300 | 200

2006 | 50 | 100

Can anyone help? Thanks!!!

[Søren Dyhr]

Well this is a kind of portalized summary, which hardly is posible without some kind of scripting in order to be reliable....

Since the calculation of the sum is more than a relation away!

Here's my stab at it!

--sd

test.zip

[deego55]

wow, you got it to work. im not sure exactly how you accomplished it yet. i will look further into your relationships. Thanks a ton. hopefully i will be able to replicate this!

[deego55]

i kind of got this to work, except that the summarized portal shows the same values in all records and the relookup script is pretty slow.

is there an easier solution, or am i missing something?

thanks for all the help!!