PEPU

Gets the percentage of ownership from the Equity Pickup (EPU) table. This function is used in Equity PickUp rules.

Syntax

HS.PEPU("S#.Y#.P#",Owner,Owned)

Return Value

The ownership percentage from the EPU table.

Example

HS.PEPU(S#Actual.Y#2014.P#Jan, Group, CT)

or

""
HS.PEPU("","","")

Default parameters: if the values are blank, the function returns the percentage of ownership for the entity pair in the current Scenario, Year, and Period.

Example

Sub EquityPickUp()
Owned=Hs.Entity.Owned
OwnerCurrencyTotl=Hs.Entity.DefCurrency & "Total"
Hs.Clear "A#Inv.C4#EPU.I#" & Owned
Hs.Exp "A#Inv.C4#EPU.I#" & Owned & "=A#EQ.C4#C3Tot.I#[ICPTot].E#" &
Owned & ".V#" & OwnerCurrencyTotl & "*" & Hs.PEPU (,,,)
End Sub