Jump to content

Getting a total of a certain value in a field in same table?


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

Recommended Posts

It is possible, but it will require two fields: a summary field defined as List of Field1 and a calculation field (result is Number) =

ValueCount ( FilterValues ( sList ; "Apple" ) )

where sList is our summary field.

The reason why this is not simple is that no single value in Field1 is supposed to be special. Filemaker provides a simple way to produce a separate count for each and every value: sort the found set by Field1 and place a summary field counting the records in a sub-summary by Field1 part.

 

Link to comment
Share on other sites

This topic is 1166 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.