How do we achieve this calculation to be implemented in FDI/OAC classic Report. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!