General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2000 Server
Perfect! Thanks David, exactly what I was looking for but would probably not have found it without your reply...
>Tom,
>
>log10() can help you in this case. You can use that to get order of magnitude and then round up or down to some number of decimal places, then take 10^ that power to get your limit.
>
>>I am writing a custom class to handle the dynamic generation of a line graph from data in a cursor. As you can imagine, I need to find the max and min values but what if they stop at an odd level?
>>
>>For instance what if I have a max value of 21.34. I suppose I could use the CEILING() function to raise to the next highest integer of 22 but what if instead that value was .2134 - I do not want to jump all the way up to 1.00. Even on the first example, perhaps 21.50 is a better upper limit but how can this be handled generically?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only