# [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?

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 €

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.