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

    Applying a Calculation Across Columns

    Michael Lance



      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).





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