I've created a custom module named "exact", for our finance dept to put in the running subscriptions for our products.

There is a formula field (YRR) that subtracts the value of two other currency fields (List price and discount).

When I enter or edit a record, the correct value is shown in the YRR field.

I have imported approximately 200 records into this module, including a List price and Discount, but the formula in the YRR field is not calculated and stays empty.

When you click and edit the values, the YRR is calculated.

I've tried editing the field (adding to the formula +1-1) to see if it would recalculate all fields on save. So far no results.

It looks like importing data does not trigger the calculation of formula fields, but I don't want to manually have to edit all records to have the fomula field calculated.

How can I populate the YRR formula field?