I am using an aggregate function (sum) in a field linked to a related database.

The field in the other database is a calculation field...

Round ( Meters–Owner * SIMs::BonusFactor perMtr ; 0 )

The problem is that when I change the value in the field, "SIMs::BonusFactor perMtr" the aggregate field does not update. As this data is important to projecting and estimating values, it needs to be current and update if any other values change.

Is there a way to make sure that the fields update ASAP ?

Thanks

I believe this is only a screen refresh issue (if you click into the field, do you see the correct value?). You can either make sure there is a window refresh following each modification of the SIMs::BonusFactor perMtr field, or change your aggregate calculation to:

Let (

trigger = SIMs::BonusFactor perMtr

;

Sum ( Related::CalculationField )

)

"I believe this is only a screen refresh issue (if you click into the field, do you see the correct value?). "

Yes to this question, but it was not always convenient and I am not the only one using the database, others are not FM dev users.

This addition to the function worked beautifully. Have not had much experience with Let.

Thanks so much.

Well, what I meant by the first suggestion was to force users into modifying the value through a scripted process only. But it should work either way.