# [SOLVED]Calculator does not display results

Home – SaaS Forums Support questions WooPrice Calculator (Pro) [SOLVED]Calculator does not display results

Viewing 7 posts - 1 through 7 (of 7 total)
• Author
Posts
• #7603
Moacyr Passos
Participant

570/5000
We did the installation of the plugin, the creation of the input and output fields and the mapping based on the calculation of the Excel spreadsheet, following all the orientation of the documentation, but unfortunately, after several attempts, the calculator provides no result is always 0.00.

The result of the calculation, when done directly in Excel works perfectly!

We use the version of WordPress 4.9.2 and Woocommerce 3.2.6 and we would like to know: does not this plugin have a bug?

And attached to the worksheet:

We appreciate the support in this problem,

Best regards,

Moacyr Passos
AgN Digital

#7609
Anonymous
Guest

Hello,
To verify and solve the problem we would appreciate if you can give us the credentials to a development environment and the excel that you use.

Best regards!
Ennie
AT81

#7608
Moacyr Passos
Participant

Hi Ennie,

Thanks for being able to verify the source of the error.

FORMULA:
The customer informs the value of the purchase of the vehicle, the amount he wishes to discount as soon as possible and the calculator must add a fixed service fee and multiply the coefficient (interest rate) corresponding to the number of monthly installments and year of vehicle.

Example:

(Total Value of the Car – Value of the Entry) + Credit Rate * coefficient (interest rate year) = final price of the monthly installment to check out the woocommerce

* All financial amounts are in Real Currency (R\$)

R\$ 50.000,00 – R\$ 20.000,00 = R\$ 30.000,00 + R\$ 1.800,00 = R\$ 31.800,00 x 0,04693 (coefficient of 2005 year) = R\$ 1.492,37 (monthly amount of 48 installments)

Total Car Value = typed by user (R\$ 50.000,00)
Input Value = entered by the user (R\$ 20.000,00)
Fixed Credit Rate = inserted in the hidden mathematical formula (R\$ 1.800,00)
Coefficient = List of coefficients based on the Year of the Automobile and number of installments financed for monthly payment. (2005 > 48 parcels > 0,04693)

#7607
Anonymous
Guest

Hello,
We are working on it, tomorrow we will contact you for your solution.

Best regards
Ennie
AT81

#7606
Anonymous
Guest

Hello,
We solved the problem , now should be everything OK. The problem was the value inserted for the list input value that should match the values used in the spreadsheet file.
Kind regards!
Ennie
AT81

#7605
Moacyr Passos
Participant

Thank you for your help Ennie!

It’s working very well!

I just want to know if in the form of the product page and also in the cart and checkout it is possible to inform the result of the amount to be financed by the client without the fee (sub_total):

SubTotal: R \$ 30.000,00

Example:

Total Car Value = typed by user + R\$ 50.000,00 (car_total_price)
Input Value = entered by the user – R\$ 20.000,00 (car_input_value)
Subtotal = Result of the amount to be financed = R\$ 30.000,00 (sub_total)

For customer information only

Thanks,

Moacyr

#7604
Anonymous
Guest

Hello,
It is able to display something on the product page creating an output_filed and give it a value by the excel file. It is not able to display such a field in the cart page or in the checkout.

Best regards
Ennie
81

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