AnsweredAssumed Answered

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

Question asked by grinch on Aug 7, 2009
Latest reply on Aug 7, 2009 by etripoli

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 

Outcomes