Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
calcuations
Hi All,
I have a requirement to display in the report the output of a calculation. screenshot below.I need to show only the total and its value(67) in the report. any way we can do it ?
Answers
-
Put the formula representing your logic - so basically all AGGREGATE AT / SUM BY statement with division into a column formula and then create a performance tile.
0 -
If you go into your analysis and "Exclude" the first 3 fields (left clik on each field and select "Exclude this field"), you will only get the final total for the fourth field.
I think that should give you what you need.
0 -
Yes but why force the query to retrieve detail data when an aggregated version is sufficient?
http://slc02okg.oracle.com:7780/analytics/saw.dll?Answers&path=%2Fshared%2FOTN%2Fcalculations
Prodney / Admin123
0 -
Hi Christian,
True, I figured out the same while trying different options in the report.Thanks for your reply.I have implemented this and it works fine. I am marking your answer.
Regards,
K
0