jschill2628
Programmer
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
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