Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Column reference with COMPUTE after ACROSS

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Column reference with COMPUTE after ACROSS
 Login/Join
 
Gold member
posted
Somehow, I just cannot figure out what is happening here. It's somewhat a matter of counting columns and referring to them in macros and stylesheets. Below, I have some code where the first two macros work perfectly (macros FUTURE & MISS). But the 3rd macro (TOL) in line does not apply conditional formatting. Again, this is referencing computed fields after an across. I believe I have the proper columns referenced for the macro "TOL". I know that N9 (VALID_OPN_DT_MAX) is the field I want formatting applied. I believe C15 (TOL_MAX_OPN_DT_FLG) is the computed field that is used in the macro.

Note: there are always two possible values in the across value of AS_OF_DT. That's why I want the 2nd across value of VALID_OPN_DT_MAX to get the conditional formatting.

Any help referencing columns or applying macros would be appreciated. I just don't know why two work, but one does not. -BobV
Frowner

TABLE FILE HOLD
SUM
OPN_DT_MIN
OPN_DT_MAX
VALID_OPN_DT_MAX
FUTURE_DT_CNT/I8C
MISSING_DT_CNT/I8C
BY SOURCE
ACROSS AS_OF_DT
COMPUTE
FUTURE_DIFF/I8 = C11 - C4; NOPRINT
COMPUTE
MISSING_DIFF/I8 = C13 - C6; NOPRINT
COMPUTE
DIF_MAX_OPN_DT/I8 = DATEDIF(C9, '&TODAY', 'D'); NOPRINT
COMPUTE
TOL_MAX_OPN_DT_FLG/A1 = IF ( ( SOURCE EQ 'AFS' OR 'ICS' OR 'CLS' OR 'MTG' OR 'RLS' OR 'STL' OR 'TST' ) AND ( DIF_MAX_OPN_DT GT 31 ) ) THEN 1 ELSE IF ( ( SOURCE EQ 'ALS' OR 'CAM' OR 'DDA' OR 'LOC' OR 'MPS' OR 'PH3' OR 'SBA' OR 'TDA' ) AND ( DIF_MAX_OPN_DT GT 3 ) ) THEN ‘Y’ ELSE ‘N’;
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
DEFMACRO=FUTURE,
MACTYPE=RULE,
WHEN=C11 NE 0,
$
DEFMACRO=MISS,
MACTYPE=RULE,
WHEN=C12 NE 0,
$
DEFMACRO=TOL,
MACTYPE=RULE,
WHEN=C15 EQ 'Y',
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N5,
COLOR='RED',
STYLE=BOLD,
MACRO=FUTURE,
$
TYPE=DATA,
COLUMN=N6,
COLOR='RED',
STYLE=BOLD,
MACRO=MISS,
$
TYPE=DATA,
COLUMN=N10,
COLOR='RED',
STYLE=BOLD,
MACRO=FUTURE,
$
TYPE=DATA,
COLUMN=N11,
COLOR='RED',
STYLE=BOLD,
MACRO=MISS,
$
TYPE=DATA,
COLUMN=N9,
COLOR='RED',
STYLE=BOLD,
MACRO=TOL,
$
ENDSTYLE
END

Was not able actually figure out this problem, but did a work around to create a print field in my hold table that feeds report. Conditional styling works much better on printed fields versus computes after an ACROSS.

This message has been edited. Last edited by: BobV,


WF (App Studio) 8.2.01m / Windows
Mainframe FOCUS 8
 
Posts: 93 | Registered: February 20, 2008Report This Post
Virtuoso
posted Hide Post
There is an error in the COMPUTE for TOL_MAX_OPN_DT_FLG. Change the digit 1 to an 'N' or 'Y' and see if that helps.

TOL_MAX_OPN_DT_FLG/A1 = IF ( ( SOURCE EQ 'AFS' OR 'ICS' OR 'CLS' OR 'MTG' OR 'RLS' OR 'STL' OR 'TST' ) AND ( DIF_MAX_OPN_DT GT 31 ) ) THEN 1 ELSE IF ( ( SOURCE EQ 'ALS' OR 'CAM' OR 'DDA' OR 'LOC' OR 'MPS' OR 'PH3' OR 'SBA' OR 'TDA' ) AND ( DIF_MAX_OPN_DT GT 3 ) ) THEN ‘Y’ ELSE ‘N’;


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Column reference with COMPUTE after ACROSS

Copyright © 1996-2020 Information Builders