We use a sum function in Knack to calculate the total # of requested days off and also the total # of approved days off. The detail records are in a “time card” table that contains all of the time worked and time not worked. We allow individuals to take either full day or 1/2 days off. We use a binary indicator in the time card table and a record rule to indicate 1/2 days off to help calculate the # of days off in each time card record.
This has worked very well for several years. However in November 2022 the sum function started summing all of the records not just the time off records for individuals. After a couple weeks this was corrected and things returned to normal. However starting 1/31/2023 the sum function started adding the 1/2 day records as full days. The record rule and values are still correct in the time card record, but when they are summed up in the Accounts table, we get whole values. It’s almost like the 1/2 values are getting rounded up before they are summed.
I logged a defect (#169876) and have followed up but there hasn’t been any resolution from Knack. Has anyone else seen anything strange with the sum function recently?