My Oracle Support Banner

Fusion OTBI - KPI Formula Filters Not Working (Doc ID 2306929.1)

Last updated on FEBRUARY 28, 2022

Applies to:

Oracle Fusion Application Toolkit - Version and later
Oracle Fusion Application Toolkit Cloud Service - Version 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.