You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need help on Count function in OTBI Analysis

edited Aug 14, 2019 8:25PM in Payables, Payments & Cash Management 3 comments

Summary

Trying to create a count column with a two columns but with restricted values

Content

Hi Gurus,

I am creating an analysis for to have a count of all the AP invoices by period for 2019.. I created a count on Invoice number but my problem is that I want to avoid the invoices with 'Canceled' status.. Can you please guide over on this? The analysis results display like this now when I added 'Validation status' column and added a filter to eliminate Canceled invoices but I want to see the total count and not by validation status..

 

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!