I have three fields -

1. quantity (the conditional is (if this field is equal to or less than 50, the total price will be 0, otherwise if 51 or more, calculate the fixed item_price by quantity)

2. item_price (the fixed price of the item )

3. Estimate Cost

4. total_price (calculate cost if quantity is => 51


I've seen the documentation here on calculations however to me it's not very clear and just not the example I can use as a guide.

Thanks in advance to anybody that can help me out.

Regards,

Kyle

Hello Kyle,

You'll want to use JavaScript to perform this conditional calculation. Here's an example that will work only if:

The shortfieldnames of your tokens are as described above:

var Qty = $(quantity);
var Price = $(item_price);
var Total = 0.00;
if(Qty > 50)
{
Total = (parseFloat(Qty) * parseFloat(Price));
}
else
{
Total = 0.00;
}

You can tailor this any way you need, but this JavaScript provided is based on my understanding of your requirements above.

You'll probably want to embed this JavaScript in your Calculate / Estimate button.

Let me know if you have any questions.

Thanks,

Ryan