Formula fix

  • Resolved diegodg78

    (@diegodg78)


    3 years, 8 months ago

    Hello, I have a formula, of a range that, if it exceeds 5000 units, the cost increases to double. But I can’t get it to work out. What am I doing wrong?

    dropDown_field_id_3 + dropDown_field_id_0 + dropDown_field_id_1 + dropDown_field_id_2 + dropDown_field_id_4 + if (range_field_id_5<5000) {range_field_id_5 *10} else {range_field_id_5*20}

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter diegodg78

    (@diegodg78)

    I get a solution! If and else must be replace by ? and :

    dropDown_field_id_3  +  dropDown_field_id_0  +  dropDown_field_id_1  +  dropDown_field_id_2  +  dropDown_field_id_4 + range_field_id_5 * (
 (0 < range_field_id_5 && range_field_id_5 < 2000) ? 10 : (
 (2000 <= range_field_id_5 && range_field_id_5 < 5000) ? 20 : (
 (5000 <= range_field_id_5) ? 40 : 0 ))
)

    Hi @diegodg78

    We are glad that you resolved it by yourself

    Feel free to contact us in case of additional questions

    regards

    Please be informed that this topic will be closed with this message. If you have any further requests please feel free to contact us.

    Kind regards

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Formula fix’ is closed to new replies.