A strange occurance in a virtual column:
I have a virtual column which does a calculation on 4 other column values. The output is meant to be a percentage (but for now, I have a decimal output).
The issue is that the virtual column RESETS to
0.00 on syncronisation.
I wanted to test the calculation, so putting the same calculation into a proper column, I synced the data again.
I videoed the screen… the fixed column ([PercentRecycleTest] at the top) calculates and displays 78%. The Virtual column [Job.percentRecycle] at the bottom of the screen starts by showing 0.78 (which is to be converted to %) but when the sync completes it resets to zero!