I noticed recently that the % column type seems to have changed.
E.g. If I use the percentage column type and set the value to 25%.
If I use a formula to multiply another value by the percentage value, it will treat it as 25 instead of 0.25.
So 100 * 25% = 2500
Instead of 25.
I believe the previous behaviour was that 100 * 25% = 25. But seems those older values have been shifted (25% is now 0.25%).
I read 0.25% as 1/4th of 1% (0.0025). So 100 x 0.25% I would normally expect the result to be 0.25.
Without using normal % numbers, the field doesn’t really have much value I think? As we could just use a # number column and input 0.25 and call it ‘percentage’.
Not a big issue anyhow.