5 Replies Latest reply on Aug 7, 2009 4:06 PM by etripoli

    Calculation problems, Should be easy, I am just dumb this morning

    grinch

      Title

      Calculation problems, Should be easy, I am just dumb this morning

      Post

      Like my subject line says, this should be easy.  I just don't see it today.

       

      last4 is a text field containing either the last 4 numbers of a credit card or the paypal transaction ID.  Posable values are a 4 digit number, or a 12 digit string, or empty.

       

      Payment type is a text field containing Payment type.  Posable values are Visa, PayPal, or empty 

       

       

      The auto enter caculation for payment type is designed to check if the proper payment type is associated with the field last4.  (Paypal transaction can not be less then 12 digits long.

      The calculation is:

       

       

      If ( Length ( last4 )  ≤ 4 and Length ( last4 )  > 1 and payment type = "PayPal";  payment type = "Visa"; payment type)

       

       

       

       

      My intentions are if the field payment type is PayPal and  last4 is a 4 digit number, last4 should automatically revert to Visa.  With the current formula, when last 4 is a 4 digit string and payment type is paypal payment type changes to 0.

       

       

      Thanks, 

      Chris