Last post Feb 02, 2012 05:14 AM by Sagar Kamate
Jan 31, 2012 08:02 PM|ableacher|LINK
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 :)
Feb 01, 2012 05: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.
Feb 01, 2012 02:02 PM|ableacher|LINK
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 #.
Feb 02, 2012 05: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.