AnsweredAssumed Answered

Summarizing fields do not aggregate all values

Question asked by PecCars on Jan 4, 2014
Latest reply on Jan 6, 2014 by philmodjunk

Title

Summarizing fields do not aggregate all values

Post

     Consider the tables Months (with 12 records one for each month of the current year), with a view Months ThisYear Arrival Month, where actual and budgeted stays are sumed up from a table called Requests. There is also a table called Budget which has entries per each month of all periods.

     In Requests::Stays there are currently entries for the months Jan, Feb, Mar, Jul, Sep from this year, since there are only bookings in those months. 

     In Budget there are entries for all months of this year.

     In my mind, in Months::Actual Stays the quantities summed up should include the values for the months Jan, Feb, Mar, Jul, Sep which is the case. Also in my mind, in Months::Actual Budget, the quantities summed up should include all entries for all months. This is not the case, in Months::Actual Budget, the quantities summed up include only the months Jan, Feb, Mar, Jul, Sep.

     What do I need to do in order for Months::Actual Budget to sum up the quantities for all months of the year ?

Screen_Shot_2014-01-04_at_23.14.26.png

Outcomes