Home Forums Product Configurator Rounding of Quantity on choice

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • Mads GundestrupMads Gundestrup
      Post count: 3


      We have a customer that wants to do rounding of quantity on the line.

      So for exampe they have to options as text with and height. Theese together form the qantity on the item that should be used.

      For this to work they need to round the quantity on the two text options.

      Can you do that with a formula on the calculation formula?

      Change of the rounding on the G/L setup only affects price and not quantity.



      Terri Vaive
        Post count: 165

        Hello Mads,

        One approach is to have 2 Options, one to capture the user input and another for the calculated rounded value.

        For example:

        1. HEIGHT Option with HEIGHT Choice selected, the user would enter the unrounded quantity (e.g., user enters 1.276)
        2. HEIGHTRND Option with HEIGHT Choice selected and the formula ROUND(HEIGHT;0.01) as its “Child Qty. Calculation Formula” (e.g., to round the entered 1.276 for the HEIGHT Option to 2 decimal places, the result will be 1.28 for the HEIGHTRND Option)

        The “Child Qty. Calculation Formula” is explained here: https://kb.dmsiworks.com/knowledge-base/configurator-option-choice/

        Available formulas here: https://kb.dmsiworks.com/knowledge-base/expression-evaluator/

        Thank you,

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