AnsweredAssumed Answered

Calculation in Table Field where if one field contains text return value from another field / Sum value of another field

Question asked by kitkit929 on Feb 19, 2019
Latest reply on Feb 20, 2019 by beverly



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.