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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

total count in bar graph

Status
Not open for further replies.

jschill2628

Programmer
Nov 3, 2009
156
US
I currently have a graph in Crystal XI; the graph is a simple stacked horizontal bar chart. I have two formulas in the “show value(s)” field:

EBP Falls Criteria_1:
If ({IRSCLAIM.SPECIAL45} = "01" and
{@Age} >= 18 and
{Subtype.CODE} <> "F150" and
{Unit.SPECIAL3} = "030" )then 1

And

Does not meet EBP Falls Criteria:
(count({IRSCLAIM.CLAIM})) - (Sum({@EBP Falls Critera_1})

And one field in the “On change of” field:
IRSCLAIM.CREATE_DT

My question is I want to show the absolute number of total fall incidents that meet the EBP Falls criteria, and the absolute total count of those that do not meet the criteria. So I want one column, with two values stacked upon each other.

Right now I am getting two columns, both with the same value for “does not meet the EBP Falls criteria”. Can you please help me with my formulas?

Thank you
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top