You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Analysis: Is it possible to add a column that summarizes Invoice Amount by Supplier?

Accepted answer
edited May 15, 2019 9:17PM in Reporting and Analytics for ERP 4 comments


I'm building an analysis in OTBI and wanted to know if it's possible to have a calculated column that summarizes one of the other columns


I'm building an OTBI Analysis using Payables Invoices - Transactions Real Time and I wanted to know if it's possible to create a calculated column that summarizes the invoice column to show total spend by that vendor for the period of the report.

For example, I have 3 columns:

Supplier          Invoice Number       Invoice Amount


I want to have 4 columns

Supplier         Invoice Number        Invoice Amount        Total Spend by Supplier


There are some summary functions in OTBI but so far they just sum up the total but not by Suppler. I don't seem to be able to "Group By" or get anything to work in the calculated field to do this.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!