[SOLVED] how to add the character '>' before the data
I have the following code:
TABLE FILE LIMIT
SUM MAX.JOB_GROUP AS 'JOB_GROUP'
TO_USER AS 'USER'
DOLLAR_LIMIT
BY JOB_GROUP NOPRINT
ON TABLE HOLD AS LIMIT2
END
The test out of this file is as follows:
ID USER LIMIT
0001872 MOOREKM 250000
0002112 DCMORGAN 2500
0002211 DCMORGAN 2500
0002922 BUTLERBH 5000
0002932 BUTLERBH 5000
We need to have it show as follows:
ID USER LIMIT 0001872 MOOREKM >250000 0002112 DCMORGAN >2500 0002211 DCMORGAN >2500 0002922 BUTLERBH >5000 0002932 BUTLERBH >5000
Is it possible?
Thanks.This message has been edited. Last edited by: kpiracha,
WebFOCUS 7.6.9 Windows 2003 HTML, Plain Text
November 23, 2010, 04:22 PM
GamP
The easiest way could be:
TABLE FILE LIMIT
SUM MAX.JOB_GROUP AS 'JOB_GROUP'
TO_USER AS 'USER'
COMPUTE BETWEEN/A1 = '>' AS ''
DOLLAR_LIMIT
BY JOB_GROUP NOPRINT
ON TABLE HOLD AS LIMIT2
END
Hope this helps ...
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
November 23, 2010, 04:36 PM
kpiracha
I get the following error:
(FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: AS (FOC009) INCOMPLETE REQUEST STATEMENT
WebFOCUS 7.6.9 Windows 2003 HTML, Plain Text
November 23, 2010, 04:38 PM
gweller
ADD a semi colon before the AS
TABLE FILE LIMIT SUM MAX.JOB_GROUP AS 'JOB_GROUP' TO_USER AS 'USER' COMPUTE BETWEEN/A1 = '>'; AS '' DOLLAR_LIMIT BY JOB_GROUP NOPRINT ON TABLE HOLD AS LIMIT2 END