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.