2 Replies Latest reply on Apr 26, 2013 8:48 PM by braxton

    Sigma Summation Function

    braxton

      Title

      Sigma Summation Function

      Post

           Using FM10.  How can I do a summation calculation or a sigma notation calculation such as the one below - Thanks:

            

            

      sigma.gif

        • 1. Re: Sigma Summation Function
          philmodjunk

               In FileMaker Advanced, you could use a recursive function to loop through the 13 values of n.

               without Advanced, you can use a looping script.

               If the number of iterations is fixed at 0 to 13 and not subject to user specified variations, you could expand the iteration into multiple addition terms.

               The looping script:

               Loop
                  Set Variable [$Sigma ; value: $SIgma + 100 * ( 8 * $n / 3 + 8 ) ]
                  Exit Loop If [ $n = 12 ]
                  Set Variable [ $n ; value: $n + 1 ]
               End Loop

          • 2. Re: Sigma Summation Function
            braxton

                 Thanks Phil.  I was hoping I just wasn't seeing the function in the reference section.  : )