I am having an issue with creating a report which would show the value of items currently in stock in my inventory system both with and without items marked as service. The information used is sorted in two tables Inventory and Items. This is how the report is set up:
Item Number Items Name Service Amount in Stock Cost per item Total cost in stock
This report is sorted by Item number (kf_Item_ID when script is run to generate the report) which is stored in the Items table with Item name, Amount in Stock and cost per Item
Service and Total cost in Stock are stored in the inventory table.
All this information is in a sub-summery part when sorted by kf_item_ID
Total cost in Stock is set with a field called cost which has the below calculation:
Items::Cost * Items::Number in Stock
What I am aiming for is a summery field at the bottom of the report which shows the total cost of all items currently in stock but I have not been able to get this at all. It keeps coming up with very large totals which do not reflect the actual cost.
Any help would be appreciated apologies as I have still very novice at filemaker!