Dynamic calculations based on other dynamic accounts in HFM 11.1.1.3
' Average Selling Price/T = NSV by product group /Volume Sold
HS.Dynamic "A#PCA0010 = A#PLM0000 / A#PCA0000"
' Average Yielded Cost /T = Total yielded cost /Volume Sold
HS.Dynamic "A#PCA0060 = A#PCA0050 / A#PCA0000"
' Average Delivered Contribution/T = Average selling price/T - Average yielded cost/T
HS.Dynamic "A#PCA0070 = A#PCA0010 - A#PCA0060"
All accounts have the same custom tables attached (custom1's only) and attributes are as follows:
PLM0000, PCA0050 = Revenue
PCA0000 = Flow
All others are Dynamic