Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 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
Not able to calculate aggregated amounts for 'Discount' Column in Purchase Order Line Detail Folder

We have a requirement to generate reports in FDI that display the following metrics for Purchase Orders (POs):
- PO amount before discount
- Discount amount
- PO amount after discount (Available)
These metrics should be available in both the document currency and the analytics currency (USD).
Specifically, we are treating the discount amount on POs as a savings measure, and require the ability to calculate the savings at various levels such as Business Unit (BU), Buyer, Department, Category, etc.
However, when using the 'Procurement - Purchase Order' subject area to create these reports, the 'Discount' column in the Purchase Order Line Detail folder only provides amounts at the line level. There is currently no functionality to aggregate these discount amounts across different levels.
This limitation prevents us from effectively analyzing and reporting on discount-related savings as required.
Please refer to SR: SR 3-37836332931 for additional context and details.