Round numbers in a formular with 3 decimals do not round properly

Check the formatting for your formula field. Decimal values default to only showing one place past the decimal point. You need to manually change the format to show more precision.

Actually, in this case it’s not the formatting: It’s that Airtable doesn’t retain significant digits when converting from a number to a text string. You can use the code from my pretty-print routines — or I think this will do what you want:

'Total weight: '&

ROUND(
	{Total Weight},
	3
	)&

REPT(
	'0',
	3-(
		LEN(
			ROUND(
				{Total Weight},
				3
				)&''
			)-FIND(
				'.',
				ROUND(
					{Total Weight},
					3
					)&''
				)
		)
	)&
	
' kg'

Edit: I chickened out and tested it, and it does do what you want. :winking_face:

'Total weight: '&

ROUND(
	{Total Weight},
	3
	)&

REPT(
	'0',
	3-(
		LEN(
			ROUND(
				{Total Weight},
				3
				)&''
			)-FIND(
				'.',
				ROUND(
					{Total Weight},
					3
					)&''
				)
		)
	)&
	
' kg'

Thank you much appreciated, taking your time.