Joined: 12 Feb 2015
Location: United States
Online Status: Offline
Posts: 46
Topic: Show record only with specific numeric length Posted: 26 Jan 2017 at 7:07pm
I have a Numeric field that have 5-12 numbers. Is there a formula to only show the record that have either more than 12 numbers or maybe even from 6-no number?
Example: {numeric.field}<=6 (disregarding the 0's)
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 27 Jan 2017 at 2:54am
It appears you have a string with numeric characters and you want to know which of these, when read as a number is <1,000,000.
Try and convert the string to a number and use that logic
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
