AnsweredAssumed Answered

Calculation including one value twice?!

Question asked by vitalseeds on Feb 4, 2019
Latest reply on Feb 5, 2019 by beverly

Hi Filemakers


I am trying to manage stock i my shop and am using a calculation to work out how much stock we have left. The stock remaining calculation is as follows:


c_Stock_Packets - c_Stock_sold - Sum ( Stock_Corrections::Quantity) - Sum (Shop_front_sales::Quantity)


For some reason the value in "Shop_front_sales::Quantity" field is being counted twice. E.g. when the value is 1, 2 are being recorded, when value is 3, 6 are being recorded. The other fields are being counted correctly.


This seems very strange - Can anybody help?