Do you want to see just one row for type B and one row for Type A or do you need to list all the individual records with a total for each type?
I guess you want something like
Type Price RunningTotal A 10 10 A 10 20 B 11 11 B 10 21 A 12 32 B 12 33
Thank you for your prompt nreplies. Maybe using the term running total was wrong. I would like for all records that are type A to show the total worth of all As. All records that are type B to show the total worth of all type Bs. Cs, Ds etc.....
so it would be
Type Price Total
A 10 32
A 12 32
A 11 32
B 10 25
B 15 25
C 10 30
C 10 30
C 10 30
I hope I explained it better this time.
Define a self join relationship (uses a second occurrence of the same table) that matches by type. Then the Sum Function can total Price From the related table occurrence. Note that this sums all records of a given type in the table--which might not work for you.
And unstored calculation field using ExecuteSQL might be also used.
I am just starting to use filemaker. Maybe you could give me more detailed instructions or a sample database where I can see what was done? Thank you kindly. I use fmp14
See if the attached gives you the idea. The key steps are:
1. Set up the relationship using Type field
2. Make the layout based on the related TO (table occurrence)
3. Set up the running total based on Type sort
4. Sort the file
runningTotalDEMO.fmp12.zip 990.1 K
For your result that sorted by type, you can use old style summary field.
1. make a summary field
total of price (don't need "running total" option. and this field is not need in layout)
2. make a calculation field
GetSummary ( totalOfPrice ; type )
3. sort records by type.
This sums on found set.