Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and exploring the core foundations for app libraries.

totals.rptHi,

I'm trying to sum the field of @Cost per group. For example, the sum of @Cost for Heat Barrier Series Glazing Bead should be $320.92.

Thansk\ for your help....

I'm trying to sum the field of @Cost per group. For example, the sum of @Cost for Heat Barrier Series Glazing Bead should be $320.92.

Thansk\ for your help....

Do more with

EXPERT OFFICE^{®} is a registered trademark of EXPERTS EXCHANGE^{®}

From your post, it seems that you're trying to get a total for group 2. Do you also need a total for any other group, or for the entire report? If so, you'll need a separate variable for each total.

Where do you want to display the total cost? The variable will be updated as the records are "printed", so you won't have a total until you get to the last record in the group/report. IOW, the total will have to be displayed at the end of the group/report.

With all of that in mind, this will get you a total for group 2:

Create a formula like the following (call it whatever you like) to initialize the variable:

```
WhilePrintingRecords;
Global NumberVar total_cost;
total_cost := 0;
""
```

The "" at the end is just so the formula doesn't produce any visible output on the report. You could also put the formula in a suppressed section, or suppress that field on the report. In my experience, the formula will still be evaluated if it's suppressed.

Put that formula in a report header section (to declare the variable for the report), and in GH2 (to reset the total for each group 2).

Change your Cost formula as follows:

```
WhilePrintingRecords;
Global NumberVar total_cost;
Local NumberVar cost;
cost := {qryCWProfiles.COST} * {qryCWProfiles.PIECE_LENGTH} * Sum ({qryCWProfiles.SUM_PIECE_COUNT}, {@AngleAndLength});
total_cost := total_cost + cost;
cost
```

The cost variable is just so the formula doesn't have to calculate the cost twice (once to add it to total_cost, and once to display the cost on the report).

Create a formula like the following (call it whatever you like) and put it in GF2 to display the total cost for group 2:

```
WhilePrintingRecords;
Global NumberVar total_cost;
total_cost
```

That should give you a total for group 2. Like I said, if you need totals for other groups, or for the entire report, then you'll need additional variables.

James

Create a formula

```
{qryCWProfiles.COST} * {qryCWProfiles.PIECE_LENGTH} * {qryCWProfiles.SUM_PIECE_COUNT}
```

Now create a summary of that formula over the appropriate group

mlmcc

Unless I'm missing something, that won't work. You're calculating a value for the detail records and summing the result. Changing the calculation to use the individual SUM_PIECE_COUNT, instead of the group total, will obviously change the detail values, giving you a different (probably much smaller) total.

James

A * B + A * C = A * (B+C)

A = {qryCWProfiles.COST} * {qryCWProfiles.PIECE_LENGT

B and C are {qryCWProfiles.SUM_PIECE_C

B + C = Sum({qryCWProfiles.SUM_PIE

By resetting on each group it is the group sum

mlmcc

To use a simple example:

If you had 3 records in the group and the COST, PIECE_LENGTH and SUM_PIECE_COUNT in those 3 records were:

1 1 2

1 1 2

1 1 2

His formula would give him:

1 * 1 * 6 = 6

1 * 1 * 6 = 6

1 * 1 * 6 = 6

Total: 18

Your formula would give him:

1 * 1 * 2 = 2

1 * 1 * 2 = 2

1 * 1 * 2 = 2

Total: 6

James

1 1 2

1 1 2

1 2 3

1 * 1 * 7 = 7

1 * 1 * 7 = 7

1 * 2 * 7 = 14

Total: 28

1 * 1 * 2 = 2

1 * 1 * 2 = 2

1 * 2 * 3 = 6

Total: 10

10 * 3 = 30

James

Sorry for the confusion. :-)

James

## Premium Content

You need an Expert Office subscription to comment.Start Free Trial