## 4 replies

Last post Feb 02, 2012 04:14 AM by Sagar Kamate

None

0 Points

2 Posts

### Running Totals

Is there anyway to do a running total using another running total?

For example, I have a running total counting how many vitals a patient recieved during a period of time and I want another running total counting how many of those totals are over a certain number? Is this possible and if so, how? When i try to evaluate using a formula, my 1st running total (the one counting the vitals) does not show up in the formula editor?

Thank you :)

Member

492 Points

169 Posts

### Re: Running Totals

Feb 01, 2012 04:04 AM|Sagar Kamate|LINK

For adding two running totals you have to use the Formula Fields for that.

Just add both the running totals on the report ans then this both fields are displayed in report fields of formula editor window.

Refer

http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-formula-field.htm

http://hammerman.com/doc/Level_2_Sample_Chapter.pdf

http://forums.asp.net/t/1209386.aspx/1

~Thanks~
Sagar Kamate, Software Engineer.
sagark_1008@yahoo.co.in

Don't forget to Mark this thread as "Answer", if it was useful to you.

None

0 Points

2 Posts

### Re: Running Totals

Will the formula field allow me to count the number of running totals that are over a certain number though?

I don't need to add two running totals. I need to find out how many of my running totals (reset by group) are greater than a certain #.

Member

492 Points

169 Posts

### Re: Running Totals

Feb 02, 2012 04:14 AM|Sagar Kamate|LINK

You can add a formula fields and add logic where you can check wheather value of running total is over a certain number if yes count otherwise not.

By this way you will get the no. of running totals over a certain number for perticular record group page whatever.

~Thanks~
Sagar Kamate, Software Engineer.
sagark_1008@yahoo.co.in

Don't forget to Mark this thread as "Answer", if it was useful to you.

Member

492 Points

169 Posts

### Re: Running Totals

Feb 02, 2012 04:14 AM|Sagar Kamate|LINK

You can add a formula fields and add logic where you can check wheather value of running total is over a certain number if yes count otherwise not.

By this way you will get the no. of running totals over a certain number for perticular record group page whatever.

~Thanks~
Sagar Kamate, Software Engineer.
sagark_1008@yahoo.co.in

Don't forget to Mark this thread as "Answer", if it was useful to you.