Aptworks Consulting

Format your FileMaker Calculations Here

Enter a valid FileMaker calculation expression or custom function:

/*====================================================================
                This is a sample nonsense calculation.                  
                      Try it out or use your own!                       
                           Author: Anonymous                            
======================================================================*/
While([counter=0;//keep track of which value we're on
values_count=5;$val[0]=381;$val[1]=261;$val[2]=144;$val[3]=155;$val[4]=96;total=0;
my_min=$val[0];my_max=$val[0]];counter<values_count;[total=total+$val[counter];my_min=Min(my_min;$val[counter]);my_max=Max(my_max;$val[counter]);counter=counter+1];list("the total is:" & total; "the average is:" & total / values_count;
      "the minimum is:"&my_mi; "the maximum is:"&my_max))&case(0;((((((((((((((((((((((((((((((((((2+2+2+2+2+2+3+ // comment
2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2+2))))))))))))))))))))))))))))))))));
Max(Min(Max(3;4);3;4);3;4))

Format

FileMaker Version:

Commas Separate:

#FormSendSuccess

#FormSendError

Caveats: (1) Do not use operators parentheses, commas, semicolons, percent signs, question marks or double spaces in your field or function names. (2) Always save a backup of your calculation. before replacing with formatted result.