DYK: Negative Number In Position Parameter

From Dwayne Wright - www.dwaynewright.com

Did You Know? (a series of quick discussions on things that you might have missed about FileMaker).
------------------------------------------------------------------------------------------------------

DID YOU KNOW?
A negative number in the parameter for the position function will go backwards? Not sure in what cases you would use this but it is interesting. Look at the below picture from my functions example file. You can see that I’m starting at position 2 but I want occurrence of negative 1 and the function works like a charm!


If you want more info on the Position function, you can read up on it in my Calculation Functions blog. Here is a direct like to the position function discussion...

http://dwaynewright.blogspot.com/2007/06/filemaker-position-function.html
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2007 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.