Virtual column value disappears on sync

[Dave2]

Hi,

I have a virtual column in a parent table that calculates the average of a percentage column from rows of a related child table. The calculated value displays initially in card and detail views on changes to the child table, but disappears after the sync is complete. I found this topic

Vanishing virtual columns on action Questions

Deleting the reference from Detail to Header removed the issue. Since the action was adding a detail it was updating the related details column which caused all other columns to recalculate.

which seems to be related, but the solution to “delete the reference” is not an option for me. Is there a way to prevent this behavior?

Thanks!