2 Replies Latest reply on Mar 30, 2016 11:43 AM by erolst

    Running total

    sudha

      Hi all,

       

      Can you please tell me the difference between total and running total in filemaker.

       

      Also another query related to Case, If we have multiple conditions satisfied in the case statement, does the output is shown based on the last satisfied condition.

       

      Thanks

        • 1. Re: Running total
          JesseH

          Sudha,

          In answer to your first question, in a summary report, "Total of" will be the total of the field you have selected for your summary seperated by each "Group", running total will give you a total of all "groups" listed prior to your sort method;

           

          EX:

          group A) sum of 5 total = 5, running total = 5

          group B) sum of 7 total = 7, running total = 12

          etc.

          etc.

           

          question 2;

          I believe the output will be the first satisfied condition.

           

          Others will correct me if I am wrong on the case statement.

           

          Jesse

          • 2. Re: Running total
            erolst

            jessehaagenson wrote:

            question 2;

            I believe the output will be the first satisfied condition.

             

            Others will correct me if I am wrong on the case statement.

             

            The result of Case() is either the result corresponding to the first test that evaluates as True, or (if defined) the default result (which isn't mandatory in Case()).

             

            So one should be careful: with

             

            Case (

            myField < 19 ; someResult ;

            myField < 7 ; someOtherResult ;

             

            a value of 5 in MyField will yield someResult, though it should be someOtherResult. Using a different order of

             

            Case (

            myField < 7 ; someOtherResult ;

            myField < 19 ; someResult ;

             

            will work as expected.