GetDynamicStat ( Function ; TableOccurrenceName ; Field )
Get a Dynamic Aggregate result by chosing either the function, the related Table Occurrence and the field
Average rating: 4.1 (33 votes) Log in to vote
Ugo Di Luca
GetDynamicStat ( $function ; $ToName ; $field )
GetDynamicStat ( scriptParameter1 ; scriptParameter2 ; scriptParameter3 )
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Custom Function by Ugo Di Luca - DLSystems - http://www.dlsystems.fr
Demo file soon available at http://www.dlsystems.fr
This is a FM 8.5 only function as it uses List ( ) - You may substitute List ( ) by one of the recursive function making use of GetNthRecord, as for example GetValueSet ( Field ; StartValue ) by Ray Cologon in order to make it work for FileMaker 8
- Dynamically Evaluate the result of the following Aggregate Functions : Max , Min, Average, Count, Sum, StDev, StDevP, Variance, VarianceP + the Last ( ) function...
- Chose any Table Occurrence and Field on which the evaluation is based.
GetDynamicStat ( "Sum" ; "IN_Invoice" ; "AmountDue" ) will evaluate the Sum of Ithe field 'AmountDue' in the Invoice Table based on the 'IN_Invoice' Table Occurrence.
Type Cast :
This function can treat text, numbers, dates, times and TimeStamps.
The result is Text and no rounding is set by default for number types imputs
Regional Language :
This function evaluates the content of a formula, based on the Aggregate Functions according to the result of the Get ( ApplicationLanguage ) - Japanese not covered -
All variables can be entered from global fields, any field or better script parameters or script variables, giving the developer a way to optimize coding.
Other Custom Function :
This function use another Custom Function, GetFieldType ( TOName ; Field )
Custom Function By Ugo Di Luca - DLSystems - http://www.dlsystems.fr
Let ( [
TOFieldJoin = TOName&"::"&Field ] ;
"FieldType ( " & " " & "Get ( FileName) " & " ; " & "\"" & TOFieldJoin & "\"" & " )"
Limitations : At the moment, the evaluation take place on the current File Only + Evaluation is dependant of the Context
Jim Randell, San Francisco
Apr 26, 2010
|just stumbled over this. looks kind of old, but will test, if works with 11, this is solution I have been thinking about, for aggregating filtered portals. setting a global as the portal filter criteria, then using same in this calc.|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.