3 Replies Latest reply on Jul 21, 2015 9:36 AM by MatthewMorgan_1

    Summing Portal with Conditions

    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