AnsweredAssumed Answered

Count problem reports

Question asked by Maikel on Feb 4, 2014
Latest reply on Feb 4, 2014 by philmodjunk

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

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

Outcomes