1 Reply Latest reply on Jan 5, 2011 9:16 AM by philmodjunk

    Changing Text Field to Calculation but not losing information

    KL

      Title

      Changing Text Field to Calculation but not losing information

      Post

      Using Filemaker Pro 11. We imported records with one being a total. Going forward we want the total field to be a calculation. When we change the field to a calculation it blanks out the field. Question. is there a way to make a field calculate after a certain record, leaving all the current records alone? thanks

        • 1. Re: Changing Text Field to Calculation but not losing information
          philmodjunk

          If all the fields referenced in your calculation come from fields in the same record, then perhaps you can use an Auto-entered calculation instead of a calculation field.

          If not, then you will need to keep your imported data in a different data field and define your calculation with an expression that returns the contents of the field with the imported data if there is data in it and calculates a total if it is empty:

           If ( IsEmpty (ImportField) ; //your calculation goes here ; Import Field )

          Note: I'm assuming that for some reason, your calculation produces a different value for your imported data than new data, otherwise you should be able to just change it to a calculation field. True, the original data is lost, but then your calculation will compute the same total as what was there originally and thus you get it back.