Here is my data

 

ID  Name      Account

1   MC1234   0000

2   MC1235   1233

3   MC1236   0000

 

So I create a running total and tell it to summerize on account

 

For evaluate I create the following formula

 

if account = '0000'

Then True

Else Flase

 

And I leave the reset to Never.

 

Well when I put the total into the report I only get 1.  And with the three records I would expect to get 2.

 

For this report I can not group all the reocrds by accounts and do an insert summary.  This report needs to be grouped differently.

Thanks for any help

then in that set Field to Summarize as Id and Type of Summary as count.

 

I think what you are doing is re-setting your account formula every time, so it is only ever 1. If you had no 0000 it would return 0

Your post seems that you built the RT correctly but you did not totally describe it so I am not sure.

Your original post indicates to me that you are placing the RT in the report header. If you do that it only evaluates the first row in the report and will show a 1 (based on your sample data). If you move it tot he report (or group) footer it will evaluate all rows and show you the reult fromt that.

Your evaluation formula does not need an if-then only needs to be

 

Lockwelles description of the formula for converting to a 1 or 0 is a uselful process if you do not have duplicates and you also want to use the insert sumamry function which allows for totals to be used in headers or group selection criteria.