AnsweredAssumed Answered

Summing Portal with Conditions

Question asked by MatthewMorgan_1 on Jul 21, 2015
Latest reply on Jul 21, 2015 by MatthewMorgan_1

Title

Summing Portal with Conditions

Post

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:

Example formula:
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...

Working.JPG

Outcomes