Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

Using sum (or other) to sum some records...not all


This topic is 7521 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

Hi all..I'm new here..so far enjoying this forum.

My problem is that i have 1 database with inventory and other for inputs in the inventory, ex. we buy 1 toner for epson and we introduce it there.

Question is how do I, in inventory, sum the records entered for tonner epson to keep the inventory updated.

Using sum, it sums all entrys not only epson toner.

Maybe its very simple...but not getting there.

Thank you in advance to any that can help.

Posted

You need a relationship between Inventory and Inputs, which filters the records you want to sum. Probably the best will be to define a global field in Inventory with a valuelist of all product names. You maybe need two fields, if you want to refine the filter by brand (Epson) AND product type (toner). Then the formula for the will look something like:

Sum("TheNameOfTheTableOccurenceWithTheRelationship"::"NameOfTheFieldToSumUp")

This will sum only the records in Inputs, where the matchfield equals the value, you choose for the global field in Inventory.

This topic is 7521 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.