summary of portal total

[Dianne]

a couple of things...

1. I have a portal which displays line items in my jobsheet/invoice layout in this layout I would like to show a total for the listed line items - how do I do this? I have tried to do a summary but it doesn't offer the line items total - am I missing something?

2. If I want to delete a line I would like to just delete the quantity field and for this to automatically delete all the info attached to this quantity - how do I set up this?

thanks in advance

[Søren Dyhr]

1) The Format is Sum(TableOccurenceName::FieldName).found in the Agregate funktions.

2) an autoenter calc with the "modify" option chosen saying Evaluate("";quantityfieldname) for each field needing to be cleared.

--sd

[Dianne]

Hi Soren

Calc for portal total worked a treat, many thanks

Still having a bit of trouble with the other problem though. I have changed type to a calculation and entered Evaluate("";quantityproduct_id) but it is coming up with an error message that an oporator is expected - what am I doing wrong?

(where do I find modify?)

Thanks again

[Søren Dyhr]

Sorry for keeping you in suspence ...meanwhile have I made you a template to investigate, chechout the upload!!!

--sd

blanker.zip