Brian Dunning's FileMaker Custom Functions

Arithmetic_Mean ( Field ; MaxLoopCount ; StartIndex ; MeanValue )

Calculate the arithmetic mean of a set of numbers.

  Average rating: 4.2 (32 votes) Log in to vote

Kevin Woods   Kevin Woods
KWoods
http://www.RivieraCouches.co.uk

Share on Facebook Share on Twitter

  Sample input:
Arithmetic_Mean ( Table1::NumberField ; Get(FoundCount) ; 1 ; 0 )
  Sample output:
1.5335589

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

Calculates the arithmetic mean of a set of numbers, by recursively calling itself for each row in a Found Set.

 

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.