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

How to calculate count based on a formula

Trading Post

Last Post by Anonymous 1 second ago

9 Posts

3 Users

0 Reactions

130 Views

RSS

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

I am running a report that pulls out HgbA1C, BP, LDL ... values and the corresponding dates. Based on the value of HgbA1C (>9, <8 and <7) I have a column to display whether it is 1 or 0.(for eg. if HgbA1C >9 then it displays 1 else 0). That formula is working correctly. next i need the follo:

total count of HgbA1C >9

total count of HgbA1C <8

total count of HgbA1C <7

at the end of the report.

I tried with formula and running total, but the total count is wrong. Can anyone please help.

Posted : June 6, 2012 1:35 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

If the running total isn't working for you, you can do it with tally formulas.

Formula TotReset (Report Header):

WhilePrintingRecords;
NumberVar cntHgb7Tot := 0;
NumberVar cntHgb8Tot := 0;
NumberVar cntHgb9Tot := 0;

Formula ProvReset (Group Header for provider):

WhilePrintingRecords;
NumberVar cntHgb7Prov := 0;
NumberVar cntHgb8Prov := 0;
NumberVar cntHgb9Prov := 0;

Formula PatTally (Group Footer for patient):

WhilePrintingRecords;
NumberVar cntHgb7Prov := 0;
NumberVar cntHgb8Prov := 0;
NumberVar cntHgb9Prov := 0;
NumberVar cntHgb7Tot := 0;
NumberVar cntHgb8Tot := 0;
NumberVar cntHgb9Tot := 0;

cntHgb7Prov := cntHgb7Prov + {@Hgb7Val};
cntHgb7Tot := cntHgb7Tot + {@Hgb7Val};
cntHgb8Prov := cntHgb8Prov + {@Hgb8Val};
// Etc.

Formula ShowHgb7Prov (Group footer for Provider):

WhilePrintingRecords;
NumberVar cntHgb7Prov;

cntHgb7Prov;

And so forth. 🙂

Posted : June 6, 2012 3:41 am

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

Thank you for your reply.

The report is not grouped by provider, but on on patient name. Since it displays multiple observations on the same line, each observation is displayed through a formula and all the formulas are kept in the group footer section. Do you have any suggestions?

Posted : June 6, 2012 4:48 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Then ignore the bits about Provider above and only use the parts that are relevant to the Report Total.

Posted : June 6, 2012 4:50 am

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

Thank you. But, I am getting only 0 as the total count. i am writing more details on the report. If you could pls help.

Hgb Value >9 <8 <7

5.9 0 0 1

8.4 0 0 0

9.8 1 0 0

5.7 0 0 1

7.6 0 1 0

>9 uses @Hgb_MoreThan9

<8 uses @Hgb_LessThan8

<7 uses @Hgb_LessThan7

@Hgb_MoreThan9

numberVar CountMoreThan9:=0;

if (Val (@HgbA1c})>9)

then

CountMoreThan9:=CountMoreThan9+1;

—————————————————-

@HgbA1c

WhilePrintingRecords;

stringvar hgba1c;

if hgba1c=""

then ""

else hgba1c;

——————————————————-

@Observations

stringVar hgba1c;

if {obs.hdid}=28

then hgba1c :={obs.obsvalue}

else hgba1c:=hgba1c;

——————————————————

obsvalue is a string field

Posted : June 6, 2012 5:28 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

should just be able to do a Sum for each column in your footer.

Posted : June 6, 2012 5:50 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

HGB Tally Demo.rpt

Posted : June 6, 2012 6:15 am

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

Thank you. I'll look into it.

Posted : June 6, 2012 6:20 am

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

Thank you to all, especially to SarekOfVulcan for your help and prompt replies.

At last, I figured it out.

When @Total_MoreThan9 is placed in the PageFooter the answer is 0.

Also, I think the mistake I was making was deleting the @Total_MoreThan9 from the group footer.

The code is given below:

——————————————————–

@ Total_MoreThan9

numberVar TotalMoreThan9;

if (val({HgbA1C})>9)

then

TotalMoreThan9:=TotalMoreThan9+1;

This formula is placed in the Group Footer (of patient name) and suppressed

——————————————————–

@ Disp_Tot_Cnt_MoreThan9

WhilePrintingRecords;
NumberVar TotalMoreThan9;

if (TotalMoreThan9<>0) then

ToText(TotalMoreThan9);

This is placed in Page Footer

——————————————————-

Posted : June 7, 2012 4:33 am

24 Forums
9,942 Topics
39.9 K Posts
0 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