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 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
GlenThis 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
|Powered by Social Strata|