AnsweredAssumed Answered

Problem getting calc field to populate properly

Question asked by bate01 on Nov 2, 2010
Latest reply on Nov 3, 2010 by philmodjunk


Problem getting calc field to populate properly


I have a problem with 2 different calc fields that I am working on. I know what I want it to do but I also know that am not telling Filemaker in a way that it understands. This may be done in one calc - I am just not sure how to proceed.

What I need is:

1) If field occupancy status is non-occupiable or vacant then field employee # = none

2) If field occupancy status = non-vacant then field current capacity = 1, if occupancy status = vacant or non-occupiable then field current capacity = 0

I hope this makes sense to someone. I am new to the calc fields and I am trying to learn quickly.

Thanks for your help.