I am new to CR and trying to create a report. I have a formula created if {dbtable.field}='FieldName' then 1 - then I have a running total sum those items to show on the report. My problem is that I am getting multiple lines for the summary. Any idea of what I need to do to correct this in some type of formula. If more info is needed to help answer question let me know.

I am searching the database for specific text to be found within the parameter that is set. The parameter is date range and a location called agency. I have it working but it gives me 3 lines every time when I would assume that having it sum it should only put 1 line for each summary.

Just a word of caution. If you use an if-then formula to return something for a distinct count it will include the false result (likely a 0 here) as part of the count so the running total result usually is over by a value of 1. You can use the NULL trepalcement trick but a simpler apporach is to forego the if-then formula entirely and just use the condition in the Running Total's evalution formula