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     [CLOSED] Doing a Count and also using HIGHEST 1
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Doing a Count and also using HIGHEST 1
 Login/Join
 
Member
posted
Hi there,

I have a report where i am using HIGHEST 1. And i also wanted to do a count of PARENTACCOUNT. Can you please tell me how to do it?

BY LOANTRACKING.PARENTACCOUNT
BY LOANTRACKING.PARENTID
BY LOAN.TYPE
BY HIGHEST 1 ModDate

If I do SUM CNT.LOANTRACKING.PARENTACCOUNT then it ignores the HIGHEST 1 and counts the extra rows that should not be included
Thank you
Glen

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 14 | Registered: January 24, 2020Reply With QuoteReport This Post
Master
posted Hide Post
Have you tried a multi-set request?

Example against the GGSALES sample file:
TABLE FILE GGSALES
-* Count all the sales records in the file.  
COUNT SEQ_NO
-* Display the highest sales amount.  
SUM   DOLLARS 
BY HIGHEST 1 DOLLARS NOPRINT 
END  




Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster
 
Posts: 810 | Registered: April 23, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Doing a Count and also using HIGHEST 1

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