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