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,

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