Summarising A Formula

[CIBS]

Hi

Using CR9 (Soon To Be CR11)

I have a report that is doing a job of telling me the resolusion if and if it was resolved the first time. The thing is I have a formula (RES) in that has a basic function displaying YES or No based on the following formula

Formula is called RES

if Maximum({THREAD_EVENT.THREAD_EVENT_CALL_NUMBER_COUNT},{CALL.CALL_NUMBER})<=1 and {THREAD.THREAD_STATUS}=8 then "YES" Else "NO"

I do have a group on the report for the CALL.CALL_NUMBER.

What I want to do is create a summary (eg Cross-Tab Table)
and it will include the following information

User
1st Time Resolution YES / NO

So what I want to do is summarise the RES formula.

How do I summarise this as When I include it in the Cross-Table Table I do not get the true values

Any Help most greatful

KInd Regards

Stephen

 

[Madawc]

Do a modified version,

if Maximum({THREAD_EVENT.THREAD_EVENT_CALL_NUMBER_COUNT},{CALL.CALL_NUMBER})<=1 and {THREAD.THREAD_STATUS}=8 
[b]then 1 
else 0[/b]

This should sum OK.

Incidentally, the original formula could more simply been done as a Boolian,

Maximum({THREAD_EVENT.THREAD_EVENT_CALL_NUMBER_COUNT},{CALL.CALL_NUMBER})<=1 and {THREAD.THREAD_STATUS}=8

This would return True or False. You could also just use its name and a formula would work if the result was True

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[CIBS]

Hi

I have tried this as you stated but when I create a sum formula for that I get the error this field can not be summerized

the could I am putting it to count the amount of 1's is

sum({@RES})

I Haven't used boolian directly before

Is there any other suggestions

Kind Regards

Stephen

 

[lbass]

Insert a crosstab and use call number as your row field and then add the following formula as your summary field:

if Maximum({THREAD_EVENT.THREAD_EVENT_CALL_NUMBER_COUNT},{CALL.CALL_NUMBER})<=1 and
{THREAD.THREAD_STATUS}=8 then 1

Use a sum, NOT a count, as the type of summary.

-LB