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

    Help creating a calculation based off date

    Sean Dugan

      Hello,

       

      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

      end

       

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