2 Replies Latest reply on Dec 3, 2012 12:04 PM by Michael Lance

    Applying a Calculation Across Columns

    Michael Lance

      Hello.

       

      I have data that looks like this:

       

      Column A:

      Special Ed? (contains 1 or 0)  

       

      Column B:

      Special Ed. Exit Date (contains a date or is blank)

       

      I am trying to build a calculation that does the following:

       

      If "Special Ed. Exit Date" is blank, then use the value in "Special Ed?" for that row.

       

      If "Special Ed. Exit Date" is not blank and is a date before today, then assign a value of 0 (else 1).

       

      Thanks,

      Michael

       

      Bonus: If "today" can be adjustable via a parametered filter, that would be ab fab (absolutely fabulous)!