Unable to run total of a checkbox field that contains fixed value and formulas

Good morning,

I understand the issue you’re facing with displaying the running total of a checkbox field containing fixed values and formulas. Let’s address this step by step.

Firstly, it seems like you’re trying to calculate the cumulative total based on the checkbox selections in the BX field, where EO and EI correspond to specific formulas.

To ensure the correct calculation, let’s review the formulas:

1. EO formula: IF(BX == 44) { 500 }
2. EI formula: IF(BX == 2 AND A <= 70) { 1600 }

For the total EZ formula, you’re adding EI + EO to get the cumulative total.

If this isn’t working as expected, it could be due to a few reasons:

1. Make sure the formulas are correctly written, with proper syntax and logical conditions.
2. Double-check that the fields referenced in the formulas (such as A) are correctly defined and accessible within your form.
3. Ensure that the total EZ formula is correctly configured to sum up the values from EI and EO.
4. Please check if all elements visibility is correct. (Hidden by default option may set values to 0)

If you’re still encountering issues, it might be helpful to review the specific settings and configurations of your calculator and formulas to identify any potential errors or conflicts. So please send your calculator imported file.

Here’s how to send the calculator as a ZIP file:
– Go to the plugin dashboard, where you manage your calculators.
– Look for an “Export” option specific to the calculator you’re experiencing issues with.
– Once exported, compress the file into a ZIP format.
– Reply to this message and attach the ZIP file.

If you need further assistance or clarification on any specific aspect, please feel free to ask. We are here to help you resolve this issue.

Warm regards,
Lisa

Hi Lisa,

Thank you for your answer.

Here my calculator : https://new.opticdesign.fr/wp-content/uploads/2024/04/cost_calculator_data_04302024074005.txt.zip

Alexis

• This reply was modified 7 months ago by alexy7.

Hello,

I appreciate you sharing the calculator file!

I’ve successfully imported your calculator to my local website and conducted testing. The formulas all seem accurate, and the calculator is displaying the total correctly. No errors are appearing in the browser console. Given that you have access to the pro plugin, I suggest creating a ticket on https://support.stylemixthemes.com/tickets/new/ to delve deeper into the matter. It’s advisable to refrain from discussing pro plugin calculator issues in public forums.

In the meantime, based on your description in the previous request, I understand that the conditions and formulas for calculating the cumulative total are structured as follows:

1. Checkbox Field Options (“EO” and “EI”):

• “EO”: Returns 500 if the checkbox value is 44.
• “EI”: Returns 1600 if the checkbox value is 2 and another field (“A”) is less than or equal to 0.

2. Cumulative Total (“EZ”): Sum of the values of “EO” and “EI” options based on their respective conditions.

Explanation:

• If checkbox value (BX) is 44, “EO” option returns 500.
• If checkbox value (BX) is 2 and “A” is less than or equal to 70, “EI” option returns 1600.
• If checkbox value (BX) is not 44 or 2, or “A” is greater than 70, both “EO” and “EI” options return 0.
• The cumulative total (EZ) is the sum of the values returned by “EO” and “EI”.

Based on the provided logic and sample inputs, your calculation logic appears correct. However, if you encounter any discrepancies or unexpected results, we can investigate further by creating a ticket and conducting a detailed analysis.

Let me know if you need any assistance!

Best regards,

Lisa