Newbies lasik Posted August 18, 2000 Newbies Share Posted August 18, 2000 is there a way to put a "+" before positive numeric fields also.. is there a way to find a range if the values are reversed? i.e. "40..20" would find the same as "20..40" instead of only finding "40" thans Link to comment Share on other sites More sharing options...
fishma Posted September 19, 2000 Share Posted September 19, 2000 You may want to use a calculated field... For example, if you want to show the "cost" field as positive or negative you could use the following calculated field... c_t_cost_display calculation(text) =If(cost > 0, "+", If(cost = 0, "", "-")) The preceding field definition displays the cost field as positive (+), negative (-), or zero (). I hope this helps you... The problem is that this field cannot be edited. It gives you the look your looking for though... Clark! [This message has been edited by fishma (edited September 19, 2000).] [This message has been edited by fishma (edited September 19, 2000).] Link to comment Share on other sites More sharing options...
fishma Posted October 17, 2000 Share Posted October 17, 2000 As for the 40...20 issue: Set the range into a global text field, and enter find mode. Then parse the field to look for the numbers preceeding and following the elipsees (...), do a comparison between the two, determine which is larger, and reset the field to the proper order (20...40). Perform your find. This is a very quick parse and reset. If you need more details, let me know... Fishma! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8599 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 accountSign in
Already have an account? Sign in here.
Sign In Now