Display Summary totals

[Baylah]

Greetings,

I have a layout with a main portal displaying XX rows. Each row, after being populated has an "amount" field that is the result of Price*Qty calcultion.

I also have a summary field "sAmount" which is a total of "amounts".

To display this summary total I have been placing a one row protal directy under the main portal in what would be a logical place for an "Order Total."

This works but the trouble is the summary field will not display a new total (after a new row is created, or a row is modified, etc)unless I "click" into the summary field essentially refreshing the field. I can (and have)written refresher scripts and linked a button to make a refreshing process more user friendly.

While these methods work I can't help but feel I am doing something fundamentally wrong because it seems like if I add/modify a row the summary should update without any additional input from the user. (for lack of a better description...just like when entering an invoice in QuickBooks)

I hope I have made my point clear enough to illicit a response. If anyone has any advice it would be greatly appreciated.

Thanks,

Steve

[Ocean West]

What I would do is make calculation field instead of a Summary field that is uses the SUM() function that totals the field in the portal.

sAmounts = Sum(your_table_occurance::amounts)

you no longer need to put it in a 1 row portal and you can either place it on the layout as a field or a merge field... like

"Your Total is >"

[Baylah]

HI O.W.

Thanks for replying so fast.

I Got it...Thank you!

Steve