How to have common elements for all facilities

Implementation - Implémentation
1

Say, we have product stock balance as elements against each facility filled up every month. Now, we have to calculate
‘stock value’ = balance x ‘unit price’

Now, this unit price is ‘fixed’ for a product and valid for all facilities. Is there any way other than storing the same price against each facility every month as element (which is a serious 1000 times duplication)?

2

Have you looked into the use of constants?

3

@olatitle so you mean, having a constant for each product’s price, say 1000 constants. Then I have to make 1000 indicators for (quantity element x price constant). Not something scalable…but will try…thanks for the idea!