//@LT Sum

Shared NumberVar LT;
LT:=LT+{@Leads}

 

Shared NumberVar LT;
LT:=0

 

Shared NumberVar LT;
{@LT Sum}/distinctcount({Matches.Orders}, {@Origin})

 

So I've placed @LT Sum in the GH for Matches.Orders as this is where the sum needs to occur. I've placed @reset at the GH for @Origin as this is where the reset to 0 needs to occur. This appears to be working but for one flaw...its duplicating one of the values.

 

for example if 4 values being summed in @LT Sum was

1

4

5

6

 

the @avg formula is spitting out 22/4 = 5.5

its adding the 6 twice. It should be 16/4 = 4.

I've verified that its doing this on every output.

 

Let me know if you can help

Yes, I displayed it and the sum formula is not doubling in the proper GH. It shows its working as it should. Its only in the GF where the avg formula shows a doubling of the largest value so in essence the average is doing (A+B+C+2*D)/4. I know I have the pieces in the right place but wasn't sure if I had to set a condition somewhere to avoid this doubling of one value.

 

I know what you mean about the distinctcount but its needed in this report.