Skip to content

Product Configurator

Rounding of Quantity on choice

Viewing 2 posts – 1 through 2 (of 2 total)
  • Author
    Posts
  • #8399
    Mads G.

    Hi

    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.

     

     

    #9756
    Terri V.
    Insight Works

    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)
  • Sign in below to reply.