Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 60 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
AP Subledger Balance by Supplier Invoice Details Report-Grand Total mismatch in exported report
User_Z5OHR
Rank 1 - Community Starter
Problem Description:
Report name: AP Subledger Balance by Supplier Invoice Details.
159 rows for a total Liability Balance Amount of 71,060,492.97 on screen.
after exporting the report, it exports 159 for a total of $72,343,504.74 which is 1,283,011.77 more than the total on the FDI page.
Proposal:
Only after changing the below filter settings, the values in exported data and on-screen match:
Aggregation method= SUM, by=FISCAL YEAR.
Benefits:
As a business user, they should be able to match the balance amount on screen vs the exported data, irrespective of any manual intervention to apply additional filter settings, as above.
2