Number to 2 decimal places: Text function and Round function not working...

[AcueductoPM]

I have the following expressions for a virtual column.  I'm trying to get the numeric value to 2 decimal places.

Concatenate(TEXT(ROUND([Consumo Grande]*1000/(24*60*60)*100)/100)," L/S") *the ROUND and TEXT functions are essentially performing the same function....limiting it to 2 decimal places...

Concatenate(ROUND([Consumo Grande]*1000/(24*60*60)*100)/100," L/S")

And I've Tried:

Concatenate(TEXT([Consumo Grande]*1000/(24*60*60)," L/S") because the TEXT function limits it to 2 decimal places.

When I save a new record to test, it shows the value to 2 decimal places ("5.08 L/S"), then quickly changes it to a value with no decimal places...("5 L/S").

If I just have the Concatenate without TEXT or ROUND...I see a very long decimal number for a very short time, then it changes to a value with no decimal places...

The column is set to type Text

[Marc_Dillon · Accepted solution]

Dividing an integer by an integer results in an integer. Change either dividend or divisor to a decimal to get a decimal result. Easy way here is to divide by 100.0 instead of 100.

Related:

Re: How to ROUND to whatever interval you want. - Google Cloud Community