Oracle Transactional Business Intelligence

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

How to Stop Duplication of Billed Amount in Analysis

Accepted answer
17
Views
1
Comments

I am attempting to build a report which will combine corporate card data and expenses data. The goal is to track corporate card transactions to the expense report level. In the example below, the transaction was coded to two different cost centers, so there are two separate lines for the transaction on my report. However, the billed amount is reporting twice. I set the billed amount to "suppressed" rather than "repeat" and that did not correct this issue. Is there a way to only report the billed amount once per transaction?


image.png


Tagged:

Best Answer