Filter(Column filter) not working in OTBI

Thanigainathan R

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)

Sinduja Sekar-Oracle

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