Skip to content

Oracle Communities

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.
Poll: Oracle Analytics Community Website Satisfaction Tell us about your satisfaction with our newly redesigned Oracle Analytics Community Website.

Oracle Transactional Business Intelligence Idea Lab

Categories

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

Support Factorial FACT() function in Answers

Submitted

11

Views

2

Comments

Steve Pryor

Steve Pryor Rank 2 - Community Beginner

Jun 30, 2016 4:00PM in Oracle Transactional Business Intelligence Idea Lab

Description

Create database function that calculates factorials

Use Case and Business Need

We are trying to convert Business Objects reports that use the FACT() function, e.g. FACT(4) = 4! = 4x3x2x1.

This function does not exist in OBI and we do not have access to create custom functions.

Please create a database function that calculates factorials.

Original Idea Number: 307d1cd6e2

Tagged:

Analysis

1

1

1 votes

Submitted · Last Updated Mar 31, 2023 1:17PM

Comments

User720640-Oracle Rank 5 - Community Champion

Aug 25, 2016 4:47AM

Thanks for the suggestion. We'll consider this request.

Ling

0
Ahmed Maher K. Rank 6 - Analytics Lead

Feb 4, 2022 6:47PM

Good idea.

0