Skip to Content
0
Former Member
Mar 03, 2009 at 05:48 PM

Acquisitions flagged using Member property

25 Views

Hi All,

I was hoping one of you could help me. I currently have a KPI that I'm working on that requires me to get the % of revenue for Acquired companies on the total Revenue. See below for desc of LegalEntity Dim:

Description Acquisition

Entity 1 Y

Entity 2 N

Entity 3 N

Sub Consolidation N

So if I have added an acquisition member property to my entity structure what would be the best way to do a calculation for Revenue / Acquisition Revenue? I was thinking I may need to create the account Acquisition Revenue and make it sum all Entities below the selected entity where the member property for Acquisition = 'Y' and then I could do the ratio in BPC Excel. I'm not sure about the syntax for that in BPC Dim logic or whether it's the best option - any advice would be appreciated.

Kind Regards,

Fiona