Combining Two Custom Fields with a Decimal

[Travis Hill]

I have an interesting scenario in which Im combining 2 custom fields using a decimal (not basic math equations +, -), The equation looks like this:

• {{customfield_17544.asNumber.floor()}}.{{customfield_17545.asNumber.floor()}}

In theory it takes two fields and makes a number in a third so for example if customfield 17544 is 1 and customfield 17545 is 10, the result will be 1.10 but, the equation keeps dropping the last zero and reflecting 1.1 which is problematic. Any thoughts?

[Bill Sheboy · Accepted solution]

Hi @Travis Hill 

I hypothesize you are putting the result in a number field, and so the last digit is truncated.  Is that correct?  If you put the values in a text field I would expect the digits to be preserved.

Kind regards,
Bill

[Travis Hill]

I believe it is a number field. Is a text field the only way to achieve this?

[Bill Sheboy]

Yes, as I do not believe the built-in plain number fields have a display mask / format.