calculations not working during import

[troque23]

Hello,

I have a field set up to calculate data based on another field that will have data imported from an excel file. What I'm discovering is that the calculation field is not calculating during the import. It will calculate when I physically enter data in the field (as opposed to imported data). Am I doing something wrong or is this a FM "feature"? I'm using FM 8 Pro on a Mac OSX.

Thanks!

Trish

[John Mark Osborne]

It sounds like you have an auto-enter calculation. If so, you need to make sure to check the option to perform auto-enter during import. You'll see this option on the last dialog after you have specified the field mapping.

[troque23]

It's not an auto-enter - it's definitely set up as a calculation field. Should I set it up as auto-enter?

I'm beginning to wonder though if this is an excel import issue because I just created a script that would calculate the same thing using the data from the imported field. It gave me the same result as the calculation field - which is 0. Hmmmm???

[troque23]

Ahh, I figured it out -- the calculations were working just fine during the import. It was the imported data that was the problem - the import had extra spaces that the calculation didn't know what to do with, so it gave me the logical answer.

The lesson: make sure your imports have no leading or trailing spaces that can affect your results!

Thanks,

Trish

[John Mark Osborne]

Thanks for posting the solution since it could help someone else.

[Lee Smith]

Use the the Trim function on the fields that have this problem.

HTH

Lee