Hi all, i have a Detail view type which shows...

Hi all, i have a Detail view type which shows %. The % showed does not have decimal whereas I have already specified it to have 2 decimal. The source spreadsheet is showing figure with 2 decimals. Am i missing out something?

0 6 362
6 REPLIES 6

tony1
New Member

@Dennis_Kok Percents should be stored in your sheet as a decimal number between 0 and 1. You can then control the number of decimal digits using the DecimalDigits setting in the column.

the quick edit column allows me to enter % with 2 decimals, but when i sync the Apps, it is not showing any decimals

 

tony1
New Member

@Dennis_Kok If you click on the -/+ or enter in a number with decimals (e.g. change the 5 to 5.5) does it work then? For me, it looks like itโ€™s only showing decimal places for numbers that have non-zero decimal digits.

@tony , in my google spreadsheet, the value is 4.5%. It somehow rounded the value and showed only 5%

@Dennis_Kok thanks for pointing this out. It should be fixed now. Please let us know if you still see any issues.

Top Labels in this Space