Super Rookie here.
I'm trying to come up with a calculation in a table that does the following:
I have a Table named "Fruit Grades".
Fields in table are:
'Types' ; = types of fruits ("Apple", "Orange", "Banana" and "Other")
'Grade A', = # of
'Grade B' = # of
'Grade C' = # of
Essentially I want to create:
> A field in this Table which returns the number of "Apple" in "Grade A".
> A field in this Table which returns the total number of "Grade A" of all fruits other than "Apple".
How can I translate the above into Calculation in FileMaker Pro 15?
Thank you in advance.