Removing decimals from a number in calculate string field

(0) Share

Report

Posted on by Megan Lisa

I have a field that needs to show the duration in weeks or years (and specifically mention weeks or years) depending on what it is. So originally I created a string field / calculated that looks like this

but the result is this:

now I don't want the many decimal places and after exhausting a few options of how to format it in a string, I decided to make another field, decimal / calculated - with 2 decimal places and then concat that into the string -

but for whatever reasoning, the result is the same... with many a decimals.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Haig Liu Microsoft Employee on at

Like (0)

Report

Hi Megan Lisa,

There is no need to set precision on single-line text fields; it is much simpler to split a calculated field into two parts.

Please check the following steps:

1.Because the calculated field cannot set a maximum and minimum value, I set the minimum value of the time field to 0 (I think the time cannot be a negative value).

2.I store the results of the preliminary calculation in a decimal calculation field with precision set to 0.

3.Create a single line text calculation field to process the preliminary calculation results obtained in the previous step.

4.After confirming that it works correctly hide the middle calculation field.

Best Regards,

Haig Liu

Was this reply helpful? Yes No