Hello,

When doing an Across type query in Focus, how do you for example set data in a count to an “x” instead of a 1.

Thanks,

?

Could you please provide more detail?

I’m creating a skill report and need report on who has certain skills from each team. What I did was create an across type query report through Focus and did a count on the reps to mark who had what skill. When you do a count, you receive a number ‘1’ for the data. I would like to replace this ‘1’ with an ‘X’ instead. Is there a way to set data = ‘x’. I’m new with FOCUS.

Thanks,
SKILLS
Rep 10 120 3 15
Joe X X X
Bill X x

Joe,

You can do this, you just have to interpret the value that will be displayed upon your report and modify it. Try the following code which uses the CAR file -

TABLE FILE CAR
SUM CNT.MODEL NOPRINT
    COMPUTE MARK_IT/A1 MISSING ON = IF CNT.MODEL GE 1 THEN 'X' ELSE MISSING;
BY CAR
ACROSS COUNTRY
END

In this code I am listing all Car values across Country. I include a CNT.MODEL in the report to count the number of MODELs but I add the NOPRINT to stop it being displayed. I need to include this in the report because I want to reference it later.
I then add a COMPUTE to interpret the value of the count at report creation time and set it to an 'X' if it has a value greater than or equal to 1, otherwise I set it to a NULL value.

Hope this helps.

T

Thanks I'll give this a try and let you know how it works.

tONY,

i KEEP GETTING THIS ERROR MESSAGE:

0 ERROR AT OR NEAR LINE 5 IN PROCEDURE MEMFEX FOCEXEC *
(FOC171) TYPE OF MISSING CALCULATION IS NOT SPECIFIED ON LEFT SIDE: ;
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND

mY CODE IS AS FOLLOWS:

TABLE FILE TBLID_SKILLS
SUM
'CNT.TBLID_SKILLS.PP_NUMBER' NOPRINT AS 'COUNT,TBLID_SKILLS.PP_NUMBER'

COMPUTE SKILLA/A1 = IF CNT.TBLID_SKILLS.PP_NUMBER GE 1 THEN 'X' ELSE MISSING;
BY
'TBLID_SKILLS.FULLNAME'
ACROSS
'TBLID_SKILLS.SKILL'
HEADING
"WHERE ( TBLID_SKILLS.TEAM_NAME EQ 'Account Mgmt 2' );
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
ENDSTYLE
END

tHANKS FOR YOUR HELP

Well, the text for error FOC171 states:

quote:

(FOC171) TYPE OF MISSING CALCULATION IS NOT SPECIFIED ON LEFT SIDE:
A computed field created through the DEFINE command or through the
COMPUTE subcommand of the MODIFY command is assigned the value
MISSING, but its definition does not specify NEEDS SOME DATA or
NEEDS ALL DATA.

But why not just change the word MISSING to a blank (eg. ' ')?

If you use missing as part of the assignment you need to define -- on in this case COMPUTE --the field with MISSING ON as Tony has done:

COMPUTE MARK_IT/A1 MISSING ON = IF CNT.MODEL GE 1 THEN 'X' ELSE MISSING;

You can do it without MISSING ON if you change to blank, as Francis suggested.

COMPUTE MARK_IT/A1 = IF CNT.MODEL GE 1 THEN 'X' ELSE ' ';

I just wanted to post an example of what Francis said to make it clear.

It ended up working. Thanks alot for all of your help.

Joe,

Glad that you got it sorted .....

And your caps lock key

T