Trying to total 2 summary fields 1

[mvalley]

I have 2 summary fields I was hoping to combine to show a total sum.
Fields are:
(1)Count of v_basic_case_data.surg_mnc and (2)Sum of @total_endo_cases.
Is this possible?

 

[lbass]

YOu need to indicate at what section level you are showing these two summaries, and at what level (grand total?) you want to show the sum of the two.

-LB

 

[mvalley]

Currently both sumaries are at the detail level. If I can not show the sum of the 2 in the detail section as well, I guess the grand total would be where I would show the sum of the 2.

 

[lbass]

How are you able to show them at the detail level? Are you using formulas? An inserted count can only be used at a group level or grand total level. If your field itself is returning the count (precalculated) please say so. If you are using formulas, show the content of the formulas here. Or are these values being returned in subreports?

Please also identify any fields you are grouping on.

It is not that what you are trying to do is complicated--we just don't have enough information.

-LB

 

[mvalley]

My apologies, I am building too many reports at the same time.

Report Group 1 shows surgeons
Total cases = Count of v_surgeon and is located in the Group 1 header

Total Endo Cases is a Sum of the formula total_endo_cases which is the following formula:
if({v_CRA_21_Endoscopy_Billing_Summary.anesthesia_used}="Y") then 1 else
if({v_CRA_21_Endoscopy_Billing_Summary.anesthesia_used}="N") then 1 else 0

This number is also in the group 1 Header.

I would like to add the Total Cases (count of field) and the Total Endo Cases (Sum of the formula) to get a grand total of these 2 fields and was wondering if this is possible.

 

[lbass]

So it sounds like you want a total of these two fields combined? This would only make some sense if the v_surgeon field was sometimes null. Assuming it is, you could use a formula like this for the grand total (in the report footer):

count({table.v_surgeon})+sum({@total_endo_cases})

A group level formula (in the group header or group footer) would look like this:

count({table.v_surgeon},{table.groupfield})+sum({@total_endo_cases},{table.groupfield})


I'm wondering whether you should modify your endo formula. If the field can be null, you should change your formula to:

if isnull({v_CRA_21_Endoscopy_Billing_Summary.anesthesia_used}) or
trim({v_CRA_21_Endoscopy_Billing_Summary.anesthesia_used}) = "" then
0 else
if({v_CRA_21_Endoscopy_Billing_Summary.anesthesia_used}="Y") then
1 else
if({v_CRA_21_Endoscopy_Billing_Summary.anesthesia_used}="N") then
1 else 0

-LB

 

[mvalley]

Your suggestion worked beautifully. Thank you for always providing such great solutions.