I am trying to autofill the agent's intials based on 3 different related field codes appearing. Below is my calc. If I do any one of these it works, but when I try to use all three, I keep getting a 0 placed in the Agent Initials field. Now each of these 3 related code fields does get an autoenter of a 0 to begin with; however, why would that get entered into the Agent field based on the formula below? Quite the mystery. See also screen shot.
If ( WRCpropcode = 0 or IsEmpty ( WRCpropcode ); ""; WRCPropertySales::ListingA
If ( WRCleasecode = 0 or IsEmpty ( WRCleasecode ); ""; WR_Vacs4Notes::ListingAgen
If ( BusProfileCode = 0 or IsEmpty ( BusProfileCode ); ""; WRCBusinessSales::ListingA