How to add OR condition in the input of the OTBI analysis
SummaryHow to add OR condition in the input of the OTBI analysis
There are suppliers whom we create only invoices and there are suppliers whom we create only PO (these suppliers get paid by credit card and the system it shows never paid).
My requirement is to generate a list of all the suppliers who have either Invoices or PO between a specific date.
I created an analysis using 'Procurement -Spend Real Time' subject area.
I have given input parameters as Invoice and PO creation date. When I selected the date range in both the input parameter, it takes AND condition, and the output is the supplier list who have invoice and PO both in the given period.