2 Replies Latest reply on Jan 4, 2013 11:19 AM by Sean Dugan

    Help creating a calculation based off date

    Sean Dugan



      Based on delivered session I need to calculate revenue. The fee in 2012 was $2.00 and in 2013 it is $2.50


      The calculation I created is as follows:


      IF [Date}<Date(1/01/2013) then

      [in-center session] * 2

      else{in-center session] * 2.50



      The result is all session are being multiplied by 2.50 so it is not recognizing that the session date was prior to 2013.