Group1: Product

  Group2: Customer      Quantity

 

We only use numbers in the 'Quantity' field however it is set as a string.

 

I used the following formula to convert the string field to a number;

 

tonumber ({PRODUCT.QUANTITY})

 

and then I created a running total using the above formula as the field to summarize.  Type of summary is 'SUM' and I am evaluating based on a change in group 1. 

 

It appears that I am getting a count instead of a sum.

 

My results look like this:

 

Product X

   Cust 1           2

   Cust 2           2

 

I feel like I am missing something really basic.  Any thoughts would be appreciated.

 

Thanks

 

I placed it on GF1 and tried switching to evaluate for each record.  Unfortunately the running total now appears to be giving a distinct count of customers as the result is equal to the number of customers in the report instead of the sum. 

Very strange.