Crystal Reports 9

[wtfman]

I have this formula:
If {@4 hr sla} < 85 then "Failing" else
If {@4 day sla} < 90 then "Failing" else
If {@14 day sla} < 99 then "Failing" else "Passing"

What I need to do is sum the number of Passing and Failing from this field.
I tried to assign a Num (1) if Passing and then sum that field but I keep getting 'cannot sum this field'.
Any ideas how to sum or count the passing and failing for this field.

 

[synapsevampire]

Try posting the exact error, not your interpretation.

You'll need to post what's in the formulas referenced by this formula.

If they are aggregate functions, this won't work, or if they don't always return a value.

You might get better assistance by providing technical information:

Crystal version
Database/connectivity used
Example data
Expected output

You may find that someone here has a different approach to your requirements.

-k

 

[wtfman]

Version CR9
Database Oracle 8i

@4 hr sla >>
{#4 hr}/{#Count CaseID}*100
(These two above are Running Total Fields)

SLA - Status >>
If {@4 hr sla} < 85 then "Failing" else
If {@4 day sla} < 90 then "Failing" else
If {@14 day sla} < 99 then "Failing" else "Passing"

So what I have is an sla that has 3 categories per site: <4hrs 85%, <4 days 90%, <14 days 99%.
So I am diving the number of failing tickets per site by the total number of tickets per site to get an Availability Percent. The above formula will then show me at a glance if that site is failing or passing.
But I have nto figured ou thow to sum the field. Either because I am summing a field populated off a string field or because I am using the Running Total Fields.

 

[synapsevampire]

You can't base a summary on a formula using embedded Running Totals.

If interested in another approach to your requirements, please post:

Example data
Expected output

-k