Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OTBI inventory report where item quantities are less than 15 for all locations

Received Response
42
Views
2
Comments
DonOtt
DonOtt Rank 1 - Community Starter
edited Aug 24, 2024 5:48PM in Oracle Transactional Business Intelligence Forum

I have one item in two locations. How can I count the quantity for both locations for each item and only show results with a total quantity of less than 15?

Result with no On-Hand Quantity filter. STN-21108 has a quantity of 84 in two locations.

Inv Balance.png

Inv Filters.png

Result with On-Hand Quantity filter. Don't want STN-21108 in results since total is 84 and not less than or equal to 15. STN-18308 is an example of the results needed since total of both locations is 3.

image.png

Answers

  • DonOtt
    DonOtt Rank 1 - Community Starter
    edited Aug 24, 2024 5:54PM

    I figured out my issue by right clicking on the results of the item column and showing subtotals.

    image.png
  • DonOtt
    DonOtt Rank 1 - Community Starter

    How can I show locations that are empty as well? If my location is empty, there is no item or quantity tied to it so the less than filter doesn't recognize those instances.

    I found a include null values property, but the analysis gives this error when adding that property.

    image.png


    image.png