1 Reply Latest reply on Feb 4, 2014 6:02 AM by philmodjunk

    Count problem reports

    Maikel

      Title

      Count problem reports

      Post

           In my Filemaker solution I use different reports. This report count not well in the footer what I'm doing wrong?

           The layout of my report is as follows,

            

      Body

           ID                    DATE              FK_aard          Cal_StartStop             SUMTOTAL

           1                  01-01-2014            2                      3

           2                  01-01-2014            2                      1

           3                  01-01-2014            1                      4

           4                  01-01-2014            2                      2

           5                  01-01-2014            1                      1

           6                   01-01-2014            3                      1

            

      Sub summary          

                                                                                                           SUMTOTAL = 12


           ==== distinction of dates ====
      Body

           ID                    DATE              FK_aard          Cal_StartStop             SUMTOTAL

           7                     02-01-2014         2                      6

           8                     02-01-2014         1                      2

            

      Sub summary          

                                                                                                           SUMTOTAL = 8

           ======================

      Footer

      “SUM Should all Cal_StartStop add together when FK_aard matches”

           SUM1  (total of all 1)            =  (7) 

           SUM2  (total of all 2)            =  (12)

           SUM3  (total of all 3)            =  (1)

            

           ==== impute for SUM*1/2/3*===

           CAL1 = If ( Fk_Aard = "1" ; 1 ; 0 )

           SUM = total of CAL1

           ==========================