GroupSum Formulas
The functions available for fair value formulas include a special GroupSum function to handle complex percentage-based fair value calculations. The format for the function is GroupSum([revenueallocationgroup,] expr).
If you do not specify a revenue allocation group, the group to which the item in the revenue element belongs is used. If you specify a revenue allocation group that no item in the arrangement belongs to, the allocation results in an error. For more information, see Adding Revenue Allocation Groups.
The expr is an expression. It may be another formula or a simple field reference.
During calculation of fair value, the reference ID for the revenue element is implicitly included when the group is determined. This reference ID defaults to the internal ID of the source. Items with different reference ID values are not included in the same GroupSum calculation. If you merge revenue arrangements and want to include additional elements in the GroupSum calculation, you must edit the reference ID.
For example, the fair value of a maintenance item is 50% of the discounted sales price of some other items included in the contract. The items on which the percentage is based have the same revenue allocation group.
A sales order is created and approved to represent the contract.
-
Maintenance is included at a nominal price in the sales order.
-
The revenue allocation group for the hardware and software is appliance.
-
The fair value formula for the maintenance item is 0.5*GroupSum(appliance, {discountedamount}).
The revenue arrangement created from the sales order includes the following values.
|
Item |
Revenue Allocation Group |
Reference ID |
Discounted Sales Amount |
Calculated Fair Value Amount |
Revenue Amount |
|---|---|---|---|---|---|
|
Hardware |
appliance |
1020 |
2,400 |
2,400 |
1,647.06 |
|
Software |
appliance |
1020 |
1,000 |
1,000 |
686.27 |
|
Maintenance |
|
1020 |
100 |
1,700 |
1,166.67 |
The revenue amounts are the amounts allocated to each revenue element in the revenue arrangement. For more information, see Fair Value and Allocation.