Calculations not working for text fields

[Eliz309]

I have several calculation fields that are pulling information (text) from related records in another file and combining/formating it so that we can export it to another program. My problem is that although the fields worked when I created them, only some of them are working now. I have checked the storage settings and it is not storing the calculation(infact I can't change that) I have gone back to test the calculations and there don't seem to be any problems, so now I am stuck. Any suggestions as to why these fields would be blank?

[Reed]

maybe there is no valid relationship for those fields to return data.

can you post the files, so others can see them?

[Eliz309]

I figured it out it was an I-D-10t problem. My calculation was Left(Product::Description, Position(Product::Description, ". ", 1,1))and in some the Product descriptions there were commas in stead of periods (data entry is great)so it wasn't completing the calculation. Thanks for your help though.