Puts data into a combination of Account, ICP, and Custom1...4 members. This function can be used in these types of rules:
HS.Exp "DestPOV = Expression"
Table 53. Syntax for Exp Function
The destination for the data is on the left side of the equal sign, and the data to be assigned is on the right side. This example sets the cell that intersects the UnitsSold account and the [None] members of the Custom dimensions to 40000:
On the right side of the equal sign, you can use Account Expression characters to represent dimension members. Thus, you can assign data for a group of cells to another group of cells. This example sets the cell that intersects the Taxes account and the [None] members of the Custom dimensions to 6 percent of the data in the cell that intersects the Sales account and the specified Custom dimensions:
HS.Exp "A#Taxes.C1#[None].C2#[None].C3#[None].C4#[None]" _ & " = A#Sales.C1#AllProducts.C2#AllCustomers.C3#[None]" _ & ".C4#[None] * .06"
You can set multiple accounts with one Exp statement. See Simultaneously Setting Several Accounts. |