Summing Portal with Conditions
Good Morning! I have a portal into employee records that has the attendance information defined by a date range. From what i've read it should be able to be summed up within the date range, however whenever i try to change the date range, the sum doesn't work anymore. The sum will add up if you include all records, but they 0 out when its within a specific date range:
If(Employee::FullName = Attendence::Name and Attendence::Date ≥ Employee::Date Start and Attendence::Date ≤ Employee::Date End; Sum ( Attendence::Sick ))
Works as pictured within full date range, doesnt filter within a smaller range...