Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 46 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 82 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
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
