Summation Problem on Group

[llaconde]

Hello everybody,

 

I have quite a problem:

 

This is my data:

circuit A:856 1010 7665

circuit B:1100 1191 3284

circuit C:958 1154 4011

-----------------------------------

Total: 526656 597841 287450415

 

As you can see my sums aren't working. I know why but I don't know how to do it.

 

The first three lines aren't some variables but are each a different field: $F{COUNT(DISTINCTGICR.OBJECTID)},

$F{COUNT(DISTINCTGICPT.SID_PT)} and $F{COUNT(DISTINCTGICPRO.IID_PRO)}.

The reason I didn't make variables is simple, in my query I have X lines of these results because for each circuit that I have, I have X troncons (that i need for something else).

And my totals are variables where I put the same fields (see above) in sums.

Do anybody have an idea of a resolution to my problem?

Thank you very much.

[llaconde]

Sorry for bothering: I found the solution:

To use a variable "sum" that is on my group "A" but that increments on my group "circuit".

Thank you anyway.