Jump to content

Calculation to display a Number or Text


This topic is 2602 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello,

 

I have a field defined as UTP. Here the data contained in the field can be either or number or a value defined by "<0.05". I have the field set as a number field. Only problem is I want to have this field default to 2 decimal places with a leading zero if the data is put in as for example ".01". When I define the field as a decimal it works but it will not display a record with "<0.05" inputted in the field. Is there a way to fix this? Maybe with a calculation that displays the value in the field.

 

Thanks

Link to comment
Share on other sites

This topic is 2602 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.