Percent field type: stored value not the correct decimal and no % symbol

Why this is a good first issue

Requires schema changes and data migration for Percent field type behavior.

AI Summary

The issue reports incorrect storage and display of Percent field values, requiring both schema changes and data migration. The solution involves modifying how values are stored (as decimals) and displayed (with % symbol), potentially affecting many parts of the codebase. The main blocker is the complexity of safely migrating existing data.

Issue Description

Description of the issue

The decimal value stored for the Percent field type should be the decimal it represents. The value entered is the value stored and displayed just like Float. The % symbol should also be displayed.

Requires a schema change, patch for all Percent fields and potentially a code refactor

Screenshot 2024-10-15 at 13 49 24 Screenshot 2024-10-15 at 13 47 22

Update Jan 2025: I have come across this again in Insights when implementing a calculated column. You have to 'fix' the percentage value by dividing by 100:

Screenshot 2025-01-10 at 18 09 12 Screenshot 2025-01-10 at 18 10 52 Screenshot 2025-01-10 at 18 13 53