Forum Stats

  • 3,757,257 Users
  • 2,251,216 Discussions
  • 7,869,781 Comments

Discussions

Cloud PBCS - Avg revenue per day

User_FW6CR
User_FW6CR Member Posts: 1 Green Ribbon

Looking to calculate avg revenue per day for each month in PBCS. Number of business days by month is different for each entity. If i load no of days in "Days" Account and Entity member, how can I achieve this by creating a dynamic calc Account member?

Thanks in advance.

Tagged:

Answers

  • Rahul S
    Rahul S Practice Director - EPM Member Posts: 1,777 Gold Trophy

    If can be achieved in multiple ways, store days no member of other dimensions (or POV members) and against say "Days per Period" account by year, period and entity or you may write a formula to populate it (former is easier).

    Create a dynamic calc member "Avg Revenue" and write formula "Revenue"/"Day per period"->[POV members]

    This seems basic, you should be able to get quite a few reference online.


    Cheers!

    Rahul S.