×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Using Recap

Using Recap

Using Recap

(OP)
Is it possible to use recap or compute on a subfoot at bottom of a table? I am writing a report that uses recap/subfoot on a sort field (works ok) but then I want to use it on a subfoot for the overall table. Is this possible?


TABLE FILE SQLHOLD
PRINT
COMPUTE COUNTER/I5=1; NOPRINT
EnterpriseName date_col service_level ASA avg_handle_time
ATA callsrd callsh per_hand callsa per_aban  
slcalls_tohalf NOPRINT
calls_answered NOPRINT
answer_wait_time NOPRINT
handle_time NOPRINT
delay_aband_calls_in_queue NOPRINT

BY PeripheralID NOPRINT
ON PeripheralID

RECAP SERP = slcalls_tohalf * 100/calls_answered; NOPRINT
RECAP ASAP = answer_wait_time/callsh; NOPRINT
RECAP AHTP = handle_time/callsh; NOPRINT
RECAP ATAP = delay_aband_calls_in_queue/callsa; NOPRINT
RECAP PRHP = callsh * 100 / (callsh + callsa); NOPRINT
RECAP PRAP = callsa * 100 / (callsh + callsa); NOPRINT

SUBFOOT
"CIC_Total:
<SERP<ASAP<AHTP<ATAP<ST.callsrd<ST.callsh<PRHP<ST.callsa<PRAP"

ON TABLE
RECAP SERPGT = slcalls_tohalf * 100/calls_answered; NOPRINT
SUBFOOT
"CIC_Total:<ST.SERPGT "

ON TABLE SET LINES 999999
ON TABLE SET PAGE-NUM OFF

RE: Using Recap

I think the following will work:

ON TABLE
RECAP SERPGT = slcalls_tohalf * 100/calls_answered;
ON TABLE SUBFOOT
"CIC_Total:<CT.SERPGT "

RE: Using Recap

(OP)
Thanks that has solved the issue.

Is there a limit to the amount of RECAP statements you can have in a focexec file? I get a error "number of RECAP statements has exceeded 7" if i have more than that number.

RE: Using Recap

You can only have six recap commands but you should be able to change your code to

RECAP SERP = slcalls_tohalf * 100/calls_answered; NOPRINT
 ASAP = answer_wait_time/callsh; NOPRINT
 AHTP = handle_time/callsh; NOPRINT
 ATAP = delay_aband_calls_in_queue/callsa; NOPRINT
 PRHP = callsh * 100 / (callsh + callsa); NOPRINT
 PRAP = callsa * 100 / (callsh + callsa); NOPRINT

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close