12 Replies Latest reply on Jun 3, 2013 12:40 PM by Joshua Milligan

    Last Date of Absence or Tardy?

    Matt Lutton

      I am attempting to show the last date of a tardy or absence.  I have a field called Absence that determines whether an absence was "tardy" or "absent".  I have created two calculated fields, one for date of last absence and one for date of last tardy, using this:

       

      FOR ABSENCES:

      case attr([Absence])

      when "Absent"

      then max([Absence Date])

      end

       

      FOR TARDIES:

      case attr([Absence])

      when "Tardy"

      then max([Absence Date])

      end

       

      I know I am missing something, as I am getting several null values.  Any help would be greatly appreciated, its probably something very simple.

       

      1) How do I show either value, and eliminate the opposing nulls in both columns

      2) Why am I getting nulls in both columns for some rows?  The data is filtered by school, time period, etc. and should only be showing students who have an absence or tardy.

       

      Here's a screenshot:

      Absence or Tardy Calc.jpg