Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] how to add the character '>' before the data
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] how to add the character '>' before the data
 Login/Join
 
Gold member
posted
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
 
Posts: 96 | Registered: March 15, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
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
 
Posts: 96 | Registered: March 15, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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


WebFOCUS 8201M/Windows Platform
 
Posts: 109 | Registered: October 31, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
awesome. It worked. Thanks a lot


WebFOCUS 7.6.9
Windows 2003
HTML, Plain Text
 
Posts: 96 | Registered: March 15, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] how to add the character '>' before the data

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.