[HIFIS3 LIST] Hifis ACER #: 01157 Attendance Monthly Report - Part2 >>> Completed
- From: <henry.dagher@xxxxxxxxxxxxxxxxx>
- To: <henry.dagher@xxxxxxxxxxxxxxxxx>, <hifis@xxxxxxxxxxxxxxxxxxxxx>, <hifis-sisa@xxxxxxxxxxxxxxxxx>, <henryd@xxxxxxxxxxxxxxxxx>, <hifis3@xxxxxxxxxxxxx>
- Date: Fri, 7 Aug 2009 15:31:13 -0400
Category: Report: Fix / Reports
Originator: Weber, Glenn
Priority: High
Issue:
In some cases it shows a single as 2 adult and doubles the stay. Is this a
repot error or data error?
Solution:
This report groups on fk_clientf AND datin, and calculates the number of adults
based on a running sum that resets on change in those two fields. The result of
this design causes a client with two stays that begin on the same date to count
multiple times. Further, the grouping formula (fk_clientf + datin) results in a
calculated date where the following will be treated as the same group, thus
continuing the running sum:
Reporting Period: April 1 2009 - April 30 2009
fk_clientf = 10, datin = April 10, 2009 => fk_clientf + datin => April 20, 2009
fk_clientf = 12, datin = April 8, 2009 => fk_clientf + datin => April 20,
2009
The age calculations are also inexact using the 365 day divisor and datin as
the age reference date which may cause the same client with multiple stays in
the same reporting period to impact totals if their age changes during that
period. This needs to be changed to use the function based age calculation.
Status: Completed
As of Version: 3.72.2146
Other related posts:
- » [HIFIS3 LIST] Hifis ACER #: 01157 Attendance Monthly Report - Part2 >>> Completed - henry.dagher
