How to add a base cost (in addition to an item cost) when quantity is >0

  • Hi Marc,

    Thank you for fixing my configurator so that the grouped layers show up. I have another issue I would appreciate your help on:

    I am trying to write a formula that adds a set value only when the quantity of the attribute is greater than 0. From your instructions, it looks like I should be able to use “value_is_in_range(from, to, val1)”, but I’m not sure how to reference the variables I want e.g. “Main Invitation: Quantity”. In essence, I want a base cost for an attribute to be added on top of the per-item cost. A formulaic example for the print method attribute would be:

    IF({Main Invitatation: Quantity}>0,(50+({Main Invitatation: Quantity}*{simple (Main Invitation: Print method):12})),0)

    So if the quantity is 0, the response is 0, otherwise I want the item quantity multiplied by the formula value of the attribute, plus a base cost of x (￡50 in this example). I might not have got the brackets in the right place, and I appreciate this doesn’t work as it would in excel, but hopefully you understand what I’m trying to do.

    Thanks again!

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Marc Lacroix

    (@marcusig)

    Hi there,

    In this instance I would use the function greater_than().
    So something like 

    greater_than({Main Invitatation: Quantity}, 0)
    * ( 
       50
       + {Main Invitatation: Quantity}*{simple (Main Invitation: Print method):12}
    )

    Greater than will be equal to 0 or 1, so if the quantity is 0, it will multiply by 0.
    I edited the formula on your test product.

    Marc

    PS: note that support for the use of add-ons should be done directly on my website.

    Thread Starter mitsubia

    (@mitsubia)

    Hi Marc,

    How do I create an account to access support on your website? It says that the email I created a demo site with isn’t registered on your site.

    I am still struggling to write the formula for this item. I have tried to set it up so that there is a base price that is added for selecting an item, this is under ‘choice extra price’. Will this automatically be added to the price or do I need to refer to this in my formula?

    I also want to have a cost per item, which I have put under the ‘calculation value’. As the calculation values will be multiplied by the quantity in my formula, that if the quantity is 0, the formula will output 0. So I don’t think it needs to have the greater than function after all, but please correct me if that’s not the case. Unfortunately I’m getting an error message, and I don’t know where I’m going wrong, so don’t know what I need to correct.

    I am happy to purchase the bundle once I know how to set up the calculations for my product. Thank you for creating such a brilliant product!

    Thanks in advance!

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.

Tags