Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Problem with Count Variable across sections

Trading Post

Last Post by Anonymous 1 second ago

6 Posts

3 Users

0 Reactions

70 Views

RSS

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

I'm having an issue when I am using a count variable. I have three groups.

Group 1 - USRINFO.SEARCHNAME
Group 2 - PERSON.SEARCHNAME
Group 3 - DOCUMENT.CLINICALDATE

At Group Footer 3, I am using a variable to count the number of office visits.Then I need to use the same variable in Group Footer 1 to calculate percentage. When I display it in Group Footer 1, it is off by 1 (incremented by 1). Also I find that some count variables automatically increment by 1 on a new page. Can anyone pls suggest a solution.

Thanks in advance for any help.

Posted : July 25, 2012 1:09 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

Make sure you're using WhilePrintingRecords in your formulas. Don't Repeat Group Header On Each Page.

Posted : July 25, 2012 1:18 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

You might try using running totals instead. They are tricky to get started with but could well be worth it.

Posted : July 25, 2012 2:12 am

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

Thank you for the replies.

I have whileprintingrecords() in the formulas. The count is correct in GF3. Only when I copy the same formula to GF1 it is incrementing by 1 (not always). Any suggestions as to why it is doing this.

I have to count office visits based on whether BP is recorded during that visit or not. Will running total work with formulas?

Any other suggestions?

Posted : July 25, 2012 5:46 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

If you're evaluating the formaula in each group footer, it will increment. I normally evaluate/increment in the detail and then just display the count in the groups.

Posted : July 25, 2012 6:03 am

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

JJordet.

Thank you for the reply.

i tried that too. i used one formula to calculate total count in GF3 and another formula to display the count variable in GF1. still not working. Do you have any other suggestions?

My report has to generate the percentage of office visits for each physician in which BP is not recorded (for patients with a certain Dx). It has location, start date and end date parameters. I am using formulas to check if BP is recorded during an office visit (Counting the records having HDID=53, 54 etc).

Can you/someone else give any other ideas(using SQL command) so the report will speed up?

Posted : July 25, 2012 6:19 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
2 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0