Concatenate a Number with Text but Output is Way t...

Tony_Insua · 06-05-2020 01:54 PM

Hi, I’ve used a concatenate expression to combine a math number and text (the text denotes the units of measure); however, I’m getting a value like this:
3.643724696 UNITS.

What can I do to the formulation so that it’s something like this:

3.64 UNITS

Thanks in advance!
Tony

Steve

If the Decimal value is from a column, you can choose the number of digits after the decimal point in the column configuration:

Tony_Insua

Hi Steve, this is exactly what I have in the column. The type is decimal and the formulation is [FTP]/[WEIGHT]. It gives me a number 3.64 which is exactly what I want; however, when I combine this column together with my stated units column CONCATENATE([WATTS/KG], " W/KG") it still gives me this long number 3.643724696 W/KG.

Koichi_Tsuji

From this useful tips and tricks.

CONCATENATE(CEILING([WATTS/KG])/100.0, " W/KG")

will do that job, I believe.

Steve

TEXT() will apply the column’s display formatting:

CONCATENATE(TEXT([WATTS/KG]), " W/KG")

See also:

Aleksi

One 100 is missing… CONCATENATE(CEILING(100*[WATTS/KG])/100.0, " W/KG")

Though if your column [WATTS/KG] is a decimal and set with 2 decimals, the CONCATENATE() should follow that.

Koichi_Tsuji

Thank you Aleksi, now I learned how to round up and down in designated decimal point through your tips.

Tony_Insua

Thanks Aleksi! Worked beautifully. Cheers

Aleksi

You’re welcome

Concatenate a Number with Text but Output is Way to many decimal places