Running Total of Specific Group

[mgkSHA]

Hello:

I am sure this question has been asked before, but I am new to Crystal Syntax and need some help.

I have a report which lists number of phone numbers called and the duration of each call from a list of extensions. I have created a report with an extension parameter, and the user selects the extension they want and they get all the phone numbers and the duration of each call. I have created two runningtotal fields, one for the number of times each phone number is called, and one to add up the total duration for each phone number.

My first runningtotal field works (#RTotal0), it populates a text box with the phone number count. I can't get the formula right for adding up the duration. As in, if a phone extension has four entries, I need (#RTotal1)to add up each duration and create a "Grandtotal" in the textbox, I have tried numerous count, sum, add, functions and I just can't get it right. Can someone tell me the appropriate formula within a runningtotal field to add up all entries within a group and provide a grand total? Thanks

 

[herbsza]

Sorry for not replying sooner but I have been away for the last couple of days.
You mention that you placed the formula in the group header
it should be in the group footer.

 

[mgkSHA]

Herbsza:

Thanks for all your help on this project. I wound up talking to my boss and getting the data that comes in to us in a different format. So instead of dealing with the string variable, I got an integer which represents raw seconds. So, I just threw a formula in that converted the raw seconds into a time. I got sick and tired of playing with this .

I appreciate all your assistance.