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 New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
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!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

Guys, I opened an SR and one of the analysts managed to help me, the solution is this: sum("Sales - CRM Resource System Usage"."Active Days Facts"."# of Logins" * 100.0 by "User"."Business Unit") / (22.0 * "Resource Facts"."# of Users") It is important to remember that the Aggregation Rule (Totals Row) field must be…

in I'm trying to use a formula that results in a percentage, but instead i'm getting a integer number Comment by User_9SMBJ Nov 22, 2023 6:46PM
It keeps giving the wrong sum and it didn't work with any of the solutions presented.

in I'm trying to use a formula that results in a percentage, but instead i'm getting a integer number Comment by User_9SMBJ Nov 22, 2023 3:11PM
It keeps giving the wrong sum and it didn't work with any of the solutions presented.

in I'm trying to use a formula that results in a percentage, but instead i'm getting a integer number Comment by User_9SMBJ Nov 21, 2023 9:22PM