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     [SOLVED]Filtering on two total fields
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]Filtering on two total fields
 Login/Join
 
Platinum Member
posted
Hello

I am trying to develop a report that reports

by payee
by user
by trxamount

the problem is one of the contidions I am filtering on is where total cnt.trxamount is greater than one. The other is where total cnt.payeename is eq to 1. How do I do both without losing the detail of the trxamounts for each payee.

I have been able to make seperate file by summing on the user field and also in the second file just counting the trxamouont. Is there a way to do it in a single pass without having to match or try to join the files back up?

Thanks
Dan

This message has been edited. Last edited by: moyer1dl,


IBM Main Frame: MVS, FIX, VSAM

Windows SQL

WF 7.7
 
Posts: 147 | Registered: June 24, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I think I solved it. I was able to use rank on the payee field and then do a lst.rank and do a where total on that field.


IBM Main Frame: MVS, FIX, VSAM

Windows SQL

WF 7.7
 
Posts: 147 | Registered: June 24, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
A multi-verb request might also work - something like this:

TABLE FILE <filename>
 SUM COMPUTE CNT_TRXAMOUNT/I9C = CNT.TRXAMOUNT ;
     COMPUTE CNT_PAYEENAME/I9C = CNT.PAYEENAME ;
 BY PAYEE
 BY USER (?)
-*
 PRINT <fieldnames>
 BY PAYEE
 BY USER
 BY TRXAMOUNT
 WHERE TOTAL CNT_TRXAMOUNT GT 1 ;
 WHERE TOTAL CNT_PAYEENAME EQ 1 ;
END


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Filtering on two total fields

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