Last Record Calculation Not Working
I created a calculated field that is supposed to pull the item name from the last invoice recorded for a customer. I was able to get this calculation to work when I was building the database and did test records, but when I imported the records, this field stopped showing data. Even when I tried entering new data, the field does not populate.
If ( IsEmpty ( Self ) ; Last ( Invoice Data::Item ) ; Self)
Any idea what could have happened?