Brian Dunning's FileMaker Custom Functions

areaCalcsByCoords ( xlist ; ylist )

Calculates the area within any shape defined by a series of coordinates.

  Average rating: 3.8 (38 votes) Log in to vote

Bill Holt   Bill Holt
Notesoft
http://www.notesoft.com

Share on Facebook Share on Twitter

  Sample input:
areaCalcsByCoords ( xlist ; ylist )

where: xlist = 12 24 32 15 12
and ylist = 0 14 29 5 0
  Sample output:
40.5

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

This function returns the area within any shape defined by X and Y coordinate lists. Another custom function is listed on this site which uses the same math technique. I'm sharing this one to demonstrate a technique I find useful. By breaking the logic into three parts - initial, final and repetitive - a CF can be used to emulate a looping behavior, much like you can do with a language like Fortran. Multiple branches can be developed which allow the CF to tackle very complex issues.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.