Search results for query: *

Hi Kerry, this may help. First convert your I fields to Alpha, then use Edit to extract the components you need. DEFINE FILE XXXX AMONTH/A11 = EDIT(MTH); AYEAR/A11 = EDIT(YR); MTHYR/A23 = EDIT(AMONTH,'$$$$$$$$$99') || '/' || EDIT(AYEAR,'$$$$$$$9999'); END

-* if you're able to identify which data is box and which is project, then something like this may do the job DEFINE FILE X LEFT_COL/A25 = IF LEFT_COL CONTAINS 'BOX' THEN LEFT_COL ELSE RIGHT_COL; RIGHT_COL/A25 = IF RIGHT_COL CONTAINS 'PROJECT' THEN RIGHT_COL ELSE LEFT_COL; END TABLE FILE X...

Hi kaeserea, you'll need to either HOLD FORMAT ALPHA or SAVE as the I6 fields are being held in internal format.

You could use EDIT eg DEFINE FILE X NFIELD/P15 = EDIT(ALPHAFIELD); END If ALPHAFIELD contains only numeric values then NFIELD will be that numeric value, otherwise if ALPHAFIELD contains alpha chars then the value of NFIELD will be zero. One problem may be that if the numeric value takes up...

In Workbench, select New Standard Report / Editor and insert the following, and then Run. What I want is to force the launch page to prompt for &TMPCNTRY so that it can be assigned to &COUNTRY. However, I want the default value of &TMPCNTRY to be 'JAPAN' in this instance (in reality the value...

Try this. You can join multiple times to the same file and use tags to identify the instance you want. JOIN MCODE1 IN FILE1 TO MCODE IN MCODE TAG T1 AS J1 JOIN MCODE2 IN FILE1 TO MCODE IN MCODE TAG T2 AS J2 JOIN MCODE3 IN FILE1 TO MCODE IN MCODE TAG T3 AS J3 DEFINE FILE FILE1 NEW_AMT/D15.2 =...

Thanks for your reply, but I'd already tried that without success. I probably should have given some more details, in that I'm trying to implement this in a default launch page in Workbench 436. I think it's got something to do with how WebFocus creates these.

Hi I'm trying to use a dm variable to assign a default value ie -SET &DEF_VAL = 'VALUE'; -DEFAULTS &RVAL = &DEF_VAL -SET &REALVAL = &RVAL; Instead of &RVAL taking the value 'VALUE' it takes '&DEF_VAL'. I've tried using .EVAL without success. Can anyone help ? thanks

If the data is sorted in Employee / Start Date order you could try something like this DEFINE FILE X OVERLAP/A1 = IF EMPLOYEE EQ LAST EMPLOYEE AND START_DATE LT LAST END_DATE THEN 'Y' ELSE 'N'; END TABLE FILE X PRINT xxx OVERLAP END

Use PRINT AMOUNT AS '&YHISMONTH.AMOUNT'

Are you on a platform where you can use FORMAT COM or FORMAT COMT ? These create comma delimited files without the restrictions associated with FORMAT LOTUS.

MATCH should do it for you, something like this MATCH FILE SALES SUM SOLD AS ALL_SOLD BY DEALER BY VEHTYPE RUN FILE SALES SUM SOLD AS EMP_SALES BY DEALER BY VEHTYPE BY EMPLOYEE AFTER MATCH HOLD AS ALLSALES OLD END This file can be used to calculate percentages etc. You may have to amend this...

ecomajor, start by ensuring the data is in the correct order then use the FST and LST operators eg TABLE FILE X PRINT * BY DATE ON TABLE HOLD END TABLE FILE HOLD SUM FST.BEGINNING INFLOW OUTFLOW LST.ENDING END

I'm not sure you can do it with a Focus file, but with a sequential file you can do this . ON TABLE SAVE AS VALUES END . WHERE NOT CUST_ID IN FILE VALUES

The synatx you're after is DTY_WTD/D12.1 = IF NOT CUST_ID IN (' M1040' ' M1041') THEN ACTUAL_$ ELSE 0; You should then be able to use a subfoot something like this ON TABLE SUBFOOT "All Totals <TOT.ACTUAL_$" "Totals excluding value <TOT.DTY_WTD

Is there a method to change the graph background colour (not ChartBackground, but the area known as PlotArea in Excel) ie the wall of a 2D chart ? thanks

Thanks Tewy, I already have the manual, although not in pdf - this looks better.

Is it possible to set the x-axis labels at an angle of 45 degrees, rather than vertical / horizontal ? Also, does anyone have any useful hints for creating "excel quality" graphs as gif files ? eg fonts / types / sizes etc. The graph's I'm creating at the moment can be blurred, jagged, and...

Sean, sorry about that, I must have been sleeping. DEFINE FILE YEARS -* assuming the format is YY or numeric FIRST_YEAR/A15 = IF OLD_YEAR EQ '2004' THEN 'First Half 2004 ELSE EDIT(OLD_YEAR); SECOND_YEAR/A15 = IF OLD_YEAR EQ '2004' THEN 'Second...

Sean, if I understand correctly, you'll need something like this DEFINE FILE YEARS -* assuming the format is YY or numeric NEW_YEAR/A15 = IF OLD_YEAR EQ '2004' THEN 'First Half ' | EDIT(OLD_YEAR) ELSE EDIT(OLD_YEAR); END TABLE FILE YEARS PRINT NEW_YEAR BY...