Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running Total - formula help needed.

Status
Not open for further replies.

SBSMedicalTech

Programmer
Apr 16, 2012
21
US
I am working on a report that takes 10 months of aging data for a medical practice. In the crystal report I have tied to this report, I am grouping by the Company then by the doctor. In my group 2 header for the Doctor, I need to return ONLY the most recent month's aging information. In my data set, I am seeing the current month and the prior 9 months of data. In my SQL, I have a column titled "Month" that counts from 1 to 10 (1 being the current date and 10 being the oldest month).

What I need assistance on is with my Group 2 Headers - (Group 1 Company, Group 2 Provider). In the header, I am adding in the aging buckets 0-30,31-60,61-90 ... etc. I tried to set these up as running totals by summing on the field and then on the "Evaluate" I tried to tell it "Use a Formula" and then used {Data.Month} = 1. I thought by telling it to pick only those where month = 1, it would provide me back with those records being the most current and in fact its giving me the oldest ones (where the month = 10) as it lists that value first in the result set via the SQL query. I only care to return back the most current date and not the oldest. Not sure what i can do to only return those - any help is appreciated.
 
I was able to solve this issue with a formula If Month=1 then (my values) else 0 and summed on them. Please disregard this question as I no longer need assistance. Thanks you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top