Conditional formulas

  • Using uni cpo plugin ,created two variables with formulas need to offer conditional preference to each variable depending with the one with more total price per scenario. First variable calculates volumetric weight multiplied by price and second one calculates weight by price .please help me

    For example A box of dimensions 100 X 75 X 60 cm weighing 20Kg is presented.

    The first step is to calculate volume weight as follows: (100x75x60)/ 6000 = 75

    So this box has a volume weight of 75 Kg.

    Second step is comparing scale weight 20kg against volume weight 75kg.

    The greater is the chargeable weight. In this case 75Kg is the chargeable weight.

    Final step is calculating the charge. As our charge is 4,99€/Kg

    Thurs box will be charged as follows: Chargeable weight x price per kilo = 75kg X 4.99 =374.25€

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

  • The topic ‘Conditional formulas’ is closed to new replies.