Oracle Fusion ERP Analytics

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

Income Statement: Branch wise Gross profit and percentage calculation

Question
5
Views
0
Comments

We need to display branch-wise gross profit and its percentage on our Income Statement report in FRS.

Here's how we envision the calculation:

 * Gross Profit: Total Revenue - Total Direct Costs

 * Gross Profit Percentage: (Gross Profit / Total Revenue) * 100

The key challenge is that we don't have a specific natural account dimension in the rows for Gross Profit itself.

We need to achieve this bifurcation and calculation directly within FRS, ideally by using formula rows or columns

that reference the existing revenue and direct cost lines. Currently, we are able to get the Total Gross profit and percentage

at for all the branches together without any bifurcation.

Can you please advise on the best approach to implement these calculations and display the branch-wise data in FRS?