I have a calculated attribute PhoneExtension and the following rule to define it
If (Staff.PhoneNumberOffice WAS CHANGED OR Staff IS NEW ) AND Staff.PhoneNumberOffice CONTAINS '9845' Then
Staff.PhoneExtension=CHARS_FROM_RIGHT(Staff.PhoneNumberOffice,5)
This rule works every time when PhoneNumberOffice attribute is changed but it does not calculate PhoneExtension when I import data, including PhoneNumberOffice from a file. What am I doing wrong?