imported data does not work the same way a record created in filemaker does

[mitchelm]

My problem is this. I have four fields which have one of two values, .5 or 1, or no value. I have a calculation field which is If(team a or team b or team ecom=.5,.5,1). What happens is records created in Filemaker work fine, but records imported into filemaker from excell do not return the logical result, and even if I attempt to change the imported data the results do no follow the calculation field. I have made sure that the number fields in excell are set to a number designation.

Any help would be greatly appreciated.

Edited January 12, 2006 by Guest

[comment]

I suspect the problem is with your calculation, and it is only by some coincidence that you don't see it with the records created in Filemaker. You haven't told us what the calculation is supposed to do, but I am guessing you want:

If( team a =.5 or team b =.5 or team ecom =.5 , .5 , 1 )

[mitchelm]

What I am trying to do is I have a number of sales records on which their can be 1 or two sales team managers involved. When I pull up the records for a team, I need to calculate whether the sales team manager is getting full credit for the deal, or is sharing credit for the deal with another sales team manager. I could have sworn that I tried that formula, but I just tried it and it is now working. Thank you for your help.