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

Hi,

 

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.

 

Cheers,

Kit

Outcomes