Fusion OTBI - KPI Formula Filters Not Working
Last updated on DECEMBER 14, 2017
Applies to:Oracle Fusion Application Toolkit - Version 18.104.22.168.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 22.214.171.124.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'))
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms