How to calculate multiplication with complex dimensions?
Dear all,
I have an issue about multiplication in Calculation Manager.
I want to calculate required materials quantity for manufacturing. Formula is given below:
RM_RequiredQuantity = FG_WIPQuantity/ 1000 * RM_EstimatedQuantity
with:
RM_RequiredQuantity: required material quantity for manufacturing
FG_WIPQuantity: production quantity of Finish Goods
RM_EstimatedQuantity: estimated material quantity per unit of product
And 3 members above are child members of Statistical, Account Dimension
I have 3 forms:
- Form A is used to enter FG_WIPQuantity
- Form B is used to enter RM_EstimatedQuantity
- Form C is used to calculate RM_RequiredQuantity
POV, Page and Row & Column are designed for 3 forms