Portal Subtotals

[DykstrL]

I have 4 portals of the same data with differing rows for each portal in a purchase order form. One of the fields is a dollar amount for a line item.

What I need to do is get a subtotal for each portal. I just can't seem to figure it out. Anyone know how I can do this?

[jteich]

sum(relationship::value)

Jens

[DykstrL]

Sorry - don't work. It either gives me just the amount for each portal row, or the total for all of the portal rows.

Maybe I need to be a little more explicit:

I have 4 portals of the same related file which has a field named "Amount" (Quantity*UnitPrice). Each portal defines specific rows to display:

Portal 1 shows rows 1-9

Portal 2 shows rows 10-34

Portal 3 shows rows 35-59

Portal 4 shows rows 60-84

I need to show (preferably just below and outside the portal) the subtotals for each portal or:

subtotal of "Amount" for portal rows 1-9

subtotal of "Amount" for portal rows 10-34

subtotal of "Amount" for portal rows 35-59

subtotal of "Amount" for portal rows 60-84

Even a custom calculation - I just can't wrap my brain around this one.

Edited June 13, 2007 by Guest

[mr_vodka]

That is because portals are merely a window to your related data. They way you pick and choose how many rows and starting row number that you want to Display is another thing. Changing the settings on the portal itself does not change the background information.

In order to achieve what you are looking for, you would need additional table occurence with relationships for each set of records or possibly you could use a recursive custom function.

[jteich]

I assumed different relationships for each portal. So now it is much clearer.

It is not elegant, but my only idea of solving this is getting each value separately with GetNthRecord and adding one by one.

Jens

[DykstrL]

Nevermind - I found another post with a custom function that works just fine. Thanx.