Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Business Intelligence Applications

OTBI Analysis - Count & Rank

Question

755

Views

Comments

David Oldfield Rank 2 - Community Beginner

Feb 23, 2022 7:43PM in Oracle Business Intelligence Applications

Hello,

I currently have the following Count formula:

COUNT("Worker"."Person Number" BY CONCAT(CONCAT("Target Bank"."Target Bank Account Branch Number", ' '), "Target Bank"."Target Bank Account Number"))

This works well, however I also need for this to Count based on the below Rank formula:

RANK("Payroll Relationship"."Payroll Relationship Creation Date" by "Worker"."Person Number")

Where the Rank = 1 only.

Is this possible to combine together so this only counts where the Rank = 1 only?