Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Treat numeric constant in calculation as a measure
Rob Roush
Rank 2 - Community Beginner
Currently when a calculation is defined as a constant (simple number) the calculation is treated as an attribute instead of a measure.
This makes it very inconvenient for using calulations for things like conditional formatting, as attributes can't be used. I've found a work around by multiplying a defined measure by zero and then adding the constant, but this is a bit silly. 😏
For example:
6
Comments
-
An interim solution would be to put SUM()
1 -
Yes, that's a much better workaround, thanks. Though still seems unnecessary.
0 -
@Rob Roush agreed.
0 -
Actually, you want to use MAX() rather than SUM(), as sum will not always equal the value you set. Possibly due to some kind of aggregation that is occurring.
1
