Categories
- All Categories
- 67 Oracle Analytics News
- 5 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 55 Oracle Analytics Data Visualizations
- 1 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Filter(Column filter) not working in OTBI
We are trying to create analysis using 'Procurement - Procure to Pay real time' subject area
Trying to get count of PO which PO amount is under 5000 using below filter
count(Distinct(Case when ("Purchase Order Measures"."Ordered Amount" < 5000 ) then ("Purchase Order"."Order") end))
Also trying to fetch the sum of PO amount which amount is less than 5000.
SUM(FILTER((( ("Purchase Order Measures"."Ordered Amount") )) USING ("Purchase Order Measures"."Ordered Amount" < 5000)))
Both above filters are not working as expected. We have also tried to use 'IS LESS THAN'/'IS GREATER THAN' keywords instead of '<'/'>' symbol
Kindly let me know how to get the both count of PO and sum of PO amount under same analysis.
(We are not suppose to analysis level filter as we need to get both less than and greater than amounts in same analysis)
Answers
-
Hi @Thanigainathan R ,
Thank you for visiting and posting in Fusion Analytics Warehouse (FAW) Product Community Page.
This forum is for FAW product and looks like your question is for Fusion Applications - OTBI.
Kindly use the below URLs to post FA-OTBI questions, submit ideas, receive support from our OTBI experts and check out the resources they have available for you.
https://community.oracle.com/products/oracleanalytics/categories/otbi
Oracle Cloud Customer Connect ( https://community.oracle.com/customerconnect )
Regards,
Sinduja
0