Oracle Transactional Business Intelligence

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

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

Received Response
31
Views
1
Comments

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?

report-output-png.png image.png
Tagged:

Answers