Hello,

I have been trying to figure out how to get the correct code to make a suggested retail price based on some user input in a sub form. I have the sub form with product rate and product category. The product rate is a lookup field and is called up by row.Product_Rate.rate The product category is a drop down field that has the values bulk, pre packed, individual, group, etc..  and is called up by row.Product_Category_Ref

I have another field in the subform called Suggested Retail Price. What I am trying to do is have the script change the suggested retail price depending on the different configurations that the two fields create. So if the user chooses Bulk and the rate is greater than 100 I want the suggested retail price to be rate * 2 however if the user chooses Pre Packed and the rate is less than 5 I want the suggested retail price to be rate * 2 /3 (those are just numbers but I think you get the idea) 

I can not seem to get the right code to allow for "Bulk" && >= 100  

I get this error

In criteria left expression is of type BIGINT and right expression is type string and the operator == is not valid.