Fusion OTBI - KPI Formula Filters Not Working
(Doc ID 2306929.1)
Last updated on FEBRUARY 28, 2022
Applies to:Oracle Fusion Application Toolkit - Version 184.108.40.206.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Customer has created KPI for reporting workshop for the bank of America project.
The KPI is based on counting the Unpaid invoices. The KPI is returning the complete count of the invoices for the BU but not the unpaid invoices.
BU1 : Total Invoice 20 . Unpaid : 5
KPI returning 20.
Formula used: FILTER(COUNT("- General Information"."Invoice Number") USING ("- Reference Information"."Payment Status Name" = 'Not paid'))
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document