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.