LynhRowe1

2 years agoQrew Member

# Can a formula numeric field be converted to a text field and not affect how past data is displayed

Hello, I have a numeric-formula [Result fixed] field that returns a null value based on whether another numeric [Result] field is greater or less than defined numeric values. Moving forward I would like to not have the formula return a null value, but instead actually display the less than or greater than sign and a value. For example if the [Result] is <4.0 (i.e. 3.5) then the [Result fixed] would display "<4.0".

Can I change the [Result fixed] from a numeric-formula field to a numeric-text field and if so will it change how past data is displayed (data entered prior to the change)?

------------------------------

lrowe

------------------------------