Subtotal is not calculated correcting for one of the custom calculated measure in the OTBI report

JennyXu

I have created a custom OTBI report DPO (Days Payables Outstanding) to look at the average days to pay vendor. The last column is a calculated measure based on the multiplication of the Payment Amount and Days to Pay (payment date - invoice date). I have enabled subtotal for the measures, however, it is not displaying the correct total for this calculated measure. Please advise why subtotal is not calculating correct?

John Hung-Oracle

Hi Varos, To better serve you, I have moved your post to the Reporting and Analytics for ERP forum since its specific to financial subject areas/use cases. Thank you.

Moved to: https://community.oracle.com/customerconnect/discussion/783657/subtotal-is-not-calculated-correcting-for-one-of-the-custom-calculated-measure-in-the-otbi-report