Focal Point
[SOLVED]Filtering on Compute Fields

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8667093976

November 18, 2015, 01:34 PM
NCochran
[SOLVED]Filtering on Compute Fields
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
November 18, 2015, 01:40 PM
Ricardo Augusto
Sure.

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


WebFOCUS 8.1.05 / APP Studio
November 19, 2015, 04:03 AM
Wep5622
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 :