Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 195 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 68 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Income Statement: Branch wise Gross profit and percentage calculation

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?
Answers
-
Hello @User_WYAB5,
Thank you for the question. This is the FDI forum (Oracle Fusion Data Intelligence).
Questions related to FRS (Financial Reporting Studio) can be answered by the Oracle Fusion General Ledger Cloud Service (Fusion Cloud ERP) forum here:
Regards,
John Whitaker
0