[SOLVED] Bug?

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • #8209
    Emilio Calvo
    Participant

    Hi, I created a formula with two formula sums with a “boolean” list with two vakues: 0.6 & 0.

    The bug is generate by 0 value. When the formula made the calculations with 0,6 value everything works fine, but when it run with 0 value return the calculation plus 2,68 €. Why?

    That value is the minimum value returned with all fields with default values.

    Any help?

    Kind regards.

    #8216
    Emilio Calvo
    Participant

    This is the formula:
    ( ( 134 / 100 ) * ( $woo_price_calc_3 / 100 ) * $price * $woo_price_calc_10 + 9.5 ) + ( ( 134 / 50 ) + ( $woo_price_calc_3 / 50 ) * 2 * $woo_price_calc_11 * $woo_price_calc_10 )

    $woo_price_calc_3: input with values from 1 to X
    $price: 9
    $woo_price_calc_10: list with values from 1 to 15
    $woo_price_calc_11: “boolean” list with value 0 or 0.6

    Where’s the issue?

    Kind regards.

    #8215
    Enrico
    Participant

    Hi Emilio,

    I tried to setup your calculator, but I get 12,30 as result which is fine. I checked the result with Excel. What result do you get?

    In the meanwhile could you please send to https://altoswebsolutions.com/contact-us your wp-admin and FTP access credentials?

    Best regards,
    Enrico

    #8214
    Emilio Calvo
    Participant

    If you have a $woo_price_calc_3 with 100, $woo_price_calc_10 with 1 and $woo_price_calc_11 with 0 you must get 21,56 €, but you get 24,24 €, 2,68 € extra. Why?

    if you have the same values but $woo_price_calc_11 with 0.6 you get the wright price, 26,64 €

    Try it, please.

    Kind regards.

    #8213
    Enrico
    Participant

    Hi Emilio,

    24,24 it’s the right result.

    Probabily you are doing manual calculator errors.

    I’m attaching the XLS document I used to do calculations, as you can see the result with your suggested input parameters is 24,24

    Best regards,
    Enrico

    #8212
    Emilio Calvo
    Participant

    🙁

    Is there any way to make a boolean formula or use an “if” statement?

    Kind regards.

    #8211
    Enrico
    Participant

    Hi Emilio,

    Is this problem related to the other one?

    If not please open another question

    Best regards,
    Enrico

    #8210
    Emilio Calvo
    Participant

    Ok, don’t worry, I have a solution 😀

    Creating a new formula:
    ( ( 134 / 100 ) * ( $woo_price_calc_3 / 100 ) * $price * $woo_price_calc_10 + 9.5 ) + ( $woo_price_calc_11 * ( ( 134 / 50 ) + ( $woo_price_calc_3 / 50 ) * 2 * 0.6 * $woo_price_calc_10 ) )

    $woo_price_calc_3: input with values from 1 to X
    $price: 9
    $woo_price_calc_10: list with values from 1 to 15
    $woo_price_calc_11: “boolean” list with value 0 or 1

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