Preserving number formatting in a concatenation

[fdmsaraiva]

I have a [Decimal] column, configured to have 1 integer and 1 decimal, so it always shows as X.X (like 5.0 or 0.5).

I also have a [Concatenation] Virtual Column that merges this [Decimal] and other values in a text string.

Problem is that in the concatenation, the decimal defaults to the standard formatting, showing no decimal places if it’s a whole number.

I thought of writing something like IF(FLOOR([Decimal])=[Decimal],[Decimal]&".0",[Decimal]), but it seems a bit inelegant and overly specific.

Is there a better way?