maryj152
asked on
Create simple calculated field in filemaker pro 10
I want to get a total in a field when the types match so that I can access it from a different related table.
Table is Events
SumCEcredits Calculation fromEvents, = If (CreditType = "CE"; Sum (NoOfCredits) ; 0)
All I get is the default of zero
Table is Events
SumCEcredits Calculation fromEvents, = If (CreditType = "CE"; Sum (NoOfCredits) ; 0)
All I get is the default of zero
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are correct that an IF statement only allows one condition and a Case statement allows multiples. I generally just use Case because it works for all situations.
ASKER
Thanks
ASKER