How do we achieve this calculation to be implemented in FDI/OAC classic Report.
Hi Team,
There is this caculation requirement in P&L report.
Please let me know if anyone has implemented a similar logic for %Calculations in FDI Classic Report.
For example:
- Total Gross Revenue = Outside Revenue + Unbilled Revenue + Intercompany Revenue (from Natural Account Hierarchy Level 28 Description) + Deferred Revenue (from Natural Account Hierarchy Level 27 Description).
- % of Total Gross Revenue = (Total Gross Revenue / Direct Revenue).
The following calculations across each row follow the same pattern (subtotal/ Direct Revenue), with Direct Revenue consistently used as the denominator. Each subtotal block has different Natural Account Hierarchy Levels. I’m using a Union report to align the different Natural Account Hierarchy Levels in order.
0