Can filtering (adding to where clause) be done on Compute fields in Info Assist or Developer StudioThis 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 :