There seems to be a bug here.
You should be able to use a Percent column and perform the raw division - “A / B”. It will then automatically convert the value to Percent and display it with the “%”.
In fact, when adding a new row or Editing a row, the VC column will calculate the value correctly.
After a sync is performed, the value reverts to zero. See images below.
Is this a known issue??
Immediately after Editing the row_____________Value goes to zero after a Sync
This issue stems from division of two Number type columns. There are two ways to still use the Percent type VC column and make the correct Percent value “stick”:
Re-dfine the number columns as Decimal with ZERO decimal digits. The values are treated like Numbers but are in fact Decimals.
Force the result in the VC to be decimal by mult one of them by “1.0” -
"A * 1.0 / B"
EDIT: This exact issue was asked back in July but was not reported as a bug. I’ll open one for it.