Categories
- All Categories
- Oracle Analytics Learning Hub
- 17 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 84 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
I'm trying to use a formula that results in a percentage, but instead i'm getting a integer number
Answers
-
Can you upload report xml and also logical sql
0 -
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 “default”.
The problem has been resolved, thank you everyone for your help.
1
