30% displayed as 3000%

AppSheet AppSheet Q&A
1

I have a Percent type column, Where I have given the initial value 30, But what it instead takes is 3000% instead of 30% in the Form. Why so ?

3X_2_f_2f8d74196d3761df03b3e02206d07c39afbbca5b.png
3X_2_f_2f8d74196d3761df03b3e02206d07c39afbbca5b.png747×313 13.3 KB

3X_d_e_de838c3630f245ad1a7a99623f87e0e833afcdd7.png
3X_d_e_de838c3630f245ad1a7a99623f87e0e833afcdd7.png752×443 15.3 KB

3X_e_9_e91b6a57054a439bd883f537974cf47b415f368c.png
3X_e_9_e91b6a57054a439bd883f537974cf47b415f368c.png759×339 19.8 KB

3X_e_6_e6dd02a30bce138bbef222982dc9732efc5f1a3b.png
3X_e_6_e6dd02a30bce138bbef222982dc9732efc5f1a3b.png601×150 3.7 KB

2

Manish_Jain1:

3X_e_6_e6dd02a30bce138bbef222982dc9732efc5f1a3b.png
3X_e_6_e6dd02a30bce138bbef222982dc9732efc5f1a3b.png601×150 3.7 KB

This is how I see in the UI

3

Please try 0.3 as the initial value.

Please take a look at the following article and the below extract from it.

3X_e_b_eb605ea7f0dd7d5801e0e652289c11cf6585c7f8.png
3X_e_b_eb605ea7f0dd7d5801e0e652289c11cf6585c7f8.png878×112 6.9 KB

3 Likes
4

Manish_Jain1:

3000% instead of 30% in the Form. Why so ?

Think of the Percent column as a Decimal value with AUTOMATIC conversion to a Percent for Display. This means all of the values in data and expressions are acted on in its Decimal form.

I hope this helps make sense of it!

3 Likes