• Resolved alexy7

    (@alexy7)


    Good morning, I am unable to display the running total of a checkbox field that contains fixed values ​​and formulas. For example, BX is the ID of the checkbox field. In BX I have EO which corresponds to the formula: IF(BX == 44) { 500 } and EI which corresponds to the formula: IF(BX == 2 AND A <= 70) { 1600 } In a total EZ formula, which I add to the total of the entire form, I therefore do EI + EO to get the cumulative total but it does not work, why? On the other hand, if I check just EO or just EI in the BX field, I have the values ​​displayed in the form total. please, can you help me? I have the latest version of the pro plugin and everything is up to date.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Lisa StylemixThemes

    (@lisastylemixthemes)

    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

    Thread Starter alexy7

    (@alexy7)

    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 2 months, 1 week ago by alexy7.
    Plugin Support Lisa StylemixThemes

    (@lisastylemixthemes)

    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

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