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]Filtering on Compute Fields
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]Filtering on Compute Fields
 Login/Join
 
Member
posted
Can filtering (adding to where clause) be done on Compute fields in Info Assist or Developer Studio

This message has been edited. Last edited by: <Emily McAllister>,


WebFOCUS 8
Windows, All Outputs
 
Posts: 5 | Registered: December 29, 2014Reply With QuoteReport This Post
Guru
posted Hide Post
Sure.

Create a HOLD and then TABLE FILE it filtering as you wish.


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
You can use WHERE TOTAL to filter on computed fields, eg.:[code]
SUM COMPUTE FOO/D12 = A + B;

BY C
WHERE TOTAL FOO LE 1000;[code]


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1652 | Location: Enschede, Netherlands | Registered: August 12, 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]Filtering on Compute Fields

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