Re: totals in repeating panels

[ Follow Ups ] [ Post Followup ] [ Order Desk Pro Support ] [ FAQ ]

Posted by Sue Sloan on March 19, 2004 at 08:48:11:

In Reply to: totals in repeating panels posted by Denny Varghese on March 18, 2004 at 11:30:35:

: Im trying to get the totals for the 'AmountPaid' column in a repeating panel for each month. Im having trouble as to how to do that. Please help!

Use a calculated type field = SSum(ordhead.AMOUNTPAID) with summary options of "All records in ordhead". Summary options are set on a tab in Field Definition after you enter the SSum formula.

Note that this will not work for the OrderTotal field because it is a summary calculated field itself. You can set up the calculated field = SSum(OrderTotal) with summary options of "All records in ordhead" but it will not show a value until you go into PrintPreview.

Sue Sloan

Follow Ups:

Post a Followup

Name    : 
E-Mail  : 
Subject : 

Comments:
: : Im trying to get the totals for the 'AmountPaid' column in a repeating panel for each month. Im having trouble as to how to do that.  Please help!

: Use a calculated type field = SSum(ordhead.AMOUNTPAID) with summary options of "All records in ordhead". Summary options are set on a tab in Field Definition after you enter the SSum formula.

: Note that this will not work for the OrderTotal field because it is a summary calculated field itself. You can set up the calculated field = SSum(OrderTotal) with summary options of "All records in ordhead" but it will not show a value until you go into PrintPreview. 

: Sue Sloan


Optional Link URL:  
Link Title:         
Optional Image URL:

[ Follow Ups ] [ Post Followup ] [ Order Desk Pro Support ] [ FAQ ]