Distinct sum 1

[valo]

Hi all I a have report with a master->detail relation between two tables, this is invoice issue, all the info is displayed correctly, grouped by invoice but my problem is that the master table contains a special charges field that I need to sum, if the invoice has two or more rows the summary process increments the amount of the special charges field by the number of rows, it is is duplicating the amount, how can I do a distinct sum taking the special amount once by invoice ?

Thanks in advance

 

[synapsevampire]

Create 3 formulas as in:

//Report Header
whileprintingrecords;
global numbervar TheSum:=0;

//Group Footer
whileprintingrecords;
global numbervar TheSum;
TheSum := TheSum+{MyTable.MyValue}

//Group Footer
whileprintingrecords;
global numbervar TheSum;
TheSum

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[MrBillSC]

Another option would be to create a running total field.
The field to summarize would be the SpecialCharges field.

The type of summary would be Sum.

You would want to Evaluate on Change of Group for MasterRecordId (you would need to group by some unique field (Id number) in the master record.

You would reset on Change of Group for the group you want to total on (Vendor Id or Customer Id?).

Hope this helps.