Calculations show as 0s in the database

Hello, I have a pretty complicated form with a lot of rules and calculations that has a weird bug. Everything works as expected on the page, all the fees are calculated as I want. However, when I select submit it and Payment method = Credit card, the calculations are showing as 0.00 in the submission database and also in the google sheets where this is integrated with. They are not even showing the $ prefix and CAD suffix.

For Payment method “Cash” and “Interac” this works without an issue, but there are no credit card fees to calculate in that case. Here is the full form:

{"type":"form","data":{"fields":[{"id":"checkbox-1","element_id":"checkbox-1","form_id":"wrapper-5117-1937","parent_group":"","type":"checkbox","options":[{"label":"Sheet music","value":"Sheet-music","key":"9251-9903","error":"","calculation":"10"}],"cols":"6","conditions":[],"wrapper_id":"wrapper-5117-1937","hidden_behavior":"zero","value_type":"checkbox","field_label":"","layout":"vertical","options_bulk_editor":"Sheet music;Sheet-music; 0","required":"","calculations":"true","options_expanded":"1","description":""},{"id":"number-1","element_id":"number-1","form_id":"wrapper-5117-1937","parent_group":"","type":"number","options":[],"cols":"6","conditions":[{"element_id":"checkbox-1","rule":"is","value":"Sheet-music"}],"wrapper_id":"wrapper-5117-1937","hidden_behavior":"zero","calculations":"true","limit_min":"1","limit_max":"150","field_label":"Quantity","placeholder":"","default_value":"1"},{"id":"checkbox-2","element_id":"checkbox-2","form_id":"wrapper-9607-8228","parent_group":"","type":"checkbox","options":[{"label":"Binder","value":"Binder","key":"9251-9903","error":"","calculation":"22"}],"cols":"6","conditions":[],"wrapper_id":"wrapper-9607-8228","hidden_behavior":"zero","value_type":"checkbox","field_label":"","layout":"vertical","options_bulk_editor":"Binder;Binder; 0","required":"","calculations":"true","options_expanded":"1","formid":"wrapper-9607-8228"},{"id":"number-2","element_id":"number-2","form_id":"wrapper-9607-8228","parent_group":"","type":"number","options":[],"cols":"6","conditions":[{"element_id":"checkbox-2","rule":"is","value":"Binder"}],"wrapper_id":"wrapper-9607-8228","hidden_behavior":"zero","calculations":"true","limit_min":"1","limit_max":"150","field_label":"Quantity","placeholder":"","default_value":"1","formid":"wrapper-4887-9273"},{"id":"checkbox-3","element_id":"checkbox-3","form_id":"wrapper-9298-1509","parent_group":"","type":"checkbox","options":[{"label":"Tote bag","value":"Tote-bag","key":"9251-9903","error":"","calculation":"21"}],"cols":"6","conditions":[],"wrapper_id":"wrapper-9298-1509","hidden_behavior":"zero","value_type":"checkbox","field_label":"","layout":"vertical","options_bulk_editor":"Tote bag;Tote-bag; 0","required":"","calculations":"true","options_expanded":"1","formid":"wrapper-9298-1509"},{"id":"number-3","element_id":"number-3","form_id":"wrapper-9298-1509","parent_group":"","type":"number","options":[],"cols":"6","conditions":[{"element_id":"checkbox-3","rule":"is","value":"Tote-bag"}],"wrapper_id":"wrapper-9298-1509","hidden_behavior":"zero","calculations":"true","limit_min":"1","limit_max":"150","field_label":"Quantity","placeholder":"","default_value":"1","formid":"wrapper-1969-8862"},{"id":"checkbox-4","element_id":"checkbox-4","form_id":"wrapper-6179-9729","parent_group":"","type":"checkbox","options":[{"label":"Socks","value":"Socks","key":"9251-9903","error":"","calculation":"18.5"}],"cols":"6","conditions":[],"wrapper_id":"wrapper-6179-9729","hidden_behavior":"zero","value_type":"checkbox","field_label":"","layout":"vertical","options_bulk_editor":"Socks;Socks; 0","required":"","calculations":"true","options_expanded":"1","formid":"wrapper-6179-9729"},{"id":"number-4","element_id":"number-4","form_id":"wrapper-6179-9729","parent_group":"","type":"number","options":[],"cols":"6","conditions":[{"element_id":"checkbox-4","rule":"is","value":"Socks"}],"wrapper_id":"wrapper-6179-9729","hidden_behavior":"zero","calculations":"true","limit_min":"1","limit_max":"150","field_label":"Quantity","placeholder":"","default_value":"1","formid":"wrapper-4316-9669"},{"id":"checkbox-5","element_id":"checkbox-5","form_id":"wrapper-2760-3001","parent_group":"","type":"checkbox","options":[{"label":"Coffee","value":"Coffee","key":"9251-9903","error":"","calculation":"2"}],"cols":"6","conditions":[],"wrapper_id":"wrapper-2760-3001","hidden_behavior":"zero","value_type":"checkbox","field_label":"","layout":"vertical","options_bulk_editor":"Coffee;Coffee; 0","required":"","calculations":"true","options_expanded":"1","formid":"wrapper-2760-3001"},{"id":"number-5","element_id":"number-5","form_id":"wrapper-2760-3001","parent_group":"","type":"number","options":[],"cols":"6","conditions":[{"element_id":"checkbox-5","rule":"is","value":"Coffee"}],"wrapper_id":"wrapper-2760-3001","hidden_behavior":"zero","calculations":"true","limit_min":"1","limit_max":"150","field_label":"Quantity","placeholder":"","default_value":"1","formid":"wrapper-6429-2521"},{"id":"checkbox-6","element_id":"checkbox-6","form_id":"wrapper-6453-1859","parent_group":"","type":"checkbox","options":[{"label":"Hot cocoa","value":"Hot-cocoa","key":"9251-9903","error":"","calculation":"2"}],"cols":"6","conditions":[],"wrapper_id":"wrapper-6453-1859","hidden_behavior":"zero","value_type":"checkbox","field_label":"","layout":"vertical","options_bulk_editor":"Hot cocoa;Hot-cocoa; 0","required":"","calculations":"true","options_expanded":"1","formid":"wrapper-6453-1859"},{"id":"number-6","element_id":"number-6","form_id":"wrapper-6453-1859","parent_group":"","type":"number","options":[],"cols":"6","conditions":[{"element_id":"checkbox-6","rule":"is","value":"Hot-cocoa"}],"wrapper_id":"wrapper-6453-1859","hidden_behavior":"zero","calculations":"true","limit_min":"1","limit_max":"150","field_label":"Quantity","placeholder":"","default_value":"1","formid":"wrapper-6548-7957"},{"id":"checkbox-7","element_id":"checkbox-7","form_id":"wrapper-9501-7653","parent_group":"","type":"checkbox","options":[{"label":"Water","value":"Water","key":"9251-9903","error":"","calculation":"2"}],"cols":"6","conditions":[],"wrapper_id":"wrapper-9501-7653","hidden_behavior":"zero","value_type":"checkbox","field_label":"","layout":"vertical","options_bulk_editor":"Water;Water; 0","required":"","calculations":"true","options_expanded":"1","formid":"wrapper-9501-7653"},{"id":"number-7","element_id":"number-7","form_id":"wrapper-9501-7653","parent_group":"","type":"number","options":[],"cols":"6","conditions":[{"element_id":"checkbox-7","rule":"is","value":"Water"}],"wrapper_id":"wrapper-9501-7653","hidden_behavior":"zero","calculations":"true","limit_min":"1","limit_max":"150","field_label":"Quantity","placeholder":"","default_value":"1","formid":"wrapper-6764-8107"},{"id":"checkbox-8","element_id":"checkbox-8","form_id":"wrapper-2904-7486","parent_group":"","type":"checkbox","options":[{"label":"Chips","value":"Chips","key":"9251-9903","error":"","calculation":"2"}],"cols":"6","conditions":[],"wrapper_id":"wrapper-2904-7486","hidden_behavior":"zero","value_type":"checkbox","field_label":"","layout":"vertical","options_bulk_editor":"Chips;Chips; 0","required":"","calculations":"true","options_expanded":"1","formid":"wrapper-2904-7486"},{"id":"number-8","element_id":"number-8","form_id":"wrapper-2904-7486","parent_group":"","type":"number","options":[],"cols":"6","conditions":[{"element_id":"checkbox-8","rule":"is","value":"Chips"}],"wrapper_id":"wrapper-2904-7486","hidden_behavior":"zero","calculations":"true","limit_min":"1","limit_max":"150","field_label":"Quantity","placeholder":"","default_value":"1","formid":"wrapper-4767-3506"},{"id":"checkbox-9","element_id":"checkbox-9","form_id":"wrapper-2853-9147","parent_group":"","type":"checkbox","options":[{"label":"Chocolate","value":"Chocolate","key":"9251-9903","error":"","calculation":"2.5"}],"cols":"6","conditions":[],"wrapper_id":"wrapper-2853-9147","hidden_behavior":"zero","value_type":"checkbox","field_label":"","layout":"vertical","options_bulk_editor":"Chocolate;Chocolate; 0","required":"","calculations":"true","options_expanded":"1","formid":"wrapper-2853-9147"},{"id":"number-9","element_id":"number-9","form_id":"wrapper-2853-9147","parent_group":"","type":"number","options":[],"cols":"6","conditions":[{"element_id":"checkbox-9","rule":"is","value":"Chocolate"}],"wrapper_id":"wrapper-2853-9147","hidden_behavior":"zero","calculations":"true","limit_min":"1","limit_max":"150","field_label":"Quantity","placeholder":"","default_value":"1","formid":"wrapper-1122-3436"},{"id":"checkbox-10","element_id":"checkbox-10","form_id":"wrapper-5007-3435","parent_group":"","type":"checkbox","options":[{"label":"Lindt","value":"Lindt","key":"9251-9903","error":"","calculation":"5"}],"cols":"6","conditions":[],"wrapper_id":"wrapper-5007-3435","hidden_behavior":"zero","value_type":"checkbox","field_label":"","layout":"vertical","options_bulk_editor":"Lindt;Lindt; 0","required":"","calculations":"true","options_expanded":"1","formid":"wrapper-5007-3435"},{"id":"number-10","element_id":"number-10","form_id":"wrapper-5007-3435","parent_group":"","type":"number","options":[],"cols":"6","conditions":[{"element_id":"checkbox-10","rule":"is","value":"Lindt"}],"wrapper_id":"wrapper-5007-3435","hidden_behavior":"zero","calculations":"true","limit_min":"1","limit_max":"150","field_label":"Quantity","placeholder":"","default_value":"1","formid":"wrapper-7396-6041"},{"id":"checkbox-11","element_id":"checkbox-11","form_id":"wrapper-6214-9803","parent_group":"","type":"checkbox","options":[{"label":"Soft drink","value":"Soft-drink","key":"9251-9903","error":"","calculation":"2"}],"cols":"6","conditions":[],"wrapper_id":"wrapper-6214-9803","hidden_behavior":"zero","value_type":"checkbox","field_label":"","layout":"vertical","options_bulk_editor":"Soft drink;Soft-drink; 0","required":"","calculations":"true","options_expanded":"1","formid":"wrapper-6214-9803"},{"id":"number-11","element_id":"number-11","form_id":"wrapper-6214-9803","parent_group":"","type":"number","options":[],"cols":"6","conditions":[{"element_id":"checkbox-11","rule":"is","value":"Soft-drink"}],"wrapper_id":"wrapper-6214-9803","hidden_behavior":"zero","calculations":"true","limit_min":"1","limit_max":"150","field_label":"Quantity","placeholder":"","default_value":"1","formid":"wrapper-9152-6665"},{"id":"select-5","element_id":"select-5","form_id":"wrapper-2504-6839","parent_group":"","type":"select","options":[{"label":"Cash","value":"Cash","limit":"","key":"7199-6148","error":"","calculation":"0"},{"label":"Credit Card","value":"Credit Card","limit":"","key":"3364-3983","error":"","calculation":"0.3"},{"label":"Interac on the spot","value":"Interac","limit":"","default":"","key":"4660-2922","error":"","calculation":"0"}],"cols":"12","conditions":[],"wrapper_id":"wrapper-2504-6839","hidden_behavior":"zero","value_type":"single","field_label":"Payment method","multiselect_style":"modern","options_bulk_editor":"Cash;Cash; 0\nCredit Card;Credit Card; 0\nInterac on the spot;Interac; 0","required":"1","options_expanded":"1","placeholder":"Choose payment metod","condition_rule":"any","condition_action":"hide","calculations":"true"},{"id":"html-2","element_id":"html-2","form_id":"wrapper-7321-4790","parent_group":"","type":"html","options":[],"cols":"12","conditions":[{"element_id":"select-5","rule":"is","value":"Credit Card"},{"element_id":"calculation-1","rule":"is_less","value":"10"}],"wrapper_id":"wrapper-7321-4790","field_label":"","variations":"<p style=\"color: red\"><strong>A credit card fee of $0.3 CAD is applied to transactions below $10 CAD<\/strong><\/p>"},{"id":"name-1","element_id":"name-1","form_id":"wrapper-4583-7529","parent_group":"","type":"name","options":[],"cols":"12","conditions":[{"element_id":"select-5","rule":"is","value":"Interac"}],"wrapper_id":"wrapper-4583-7529","field_label":"Name","placeholder":"E.g. John Doe","prefix_label":"Prefix","fname_label":"First Name","fname_placeholder":"","mname_label":"Middle Name","mname_placeholder":"E.g. Smith","lname_label":"Last Name","lname_placeholder":"","prefix":"","fname":"true","mname":"","lname":"true","required_message":"Name is required.","prefix_required_message":"Prefix is required.","fname_required_message":"First Name is required.","mname_required_message":"Middle Name is required.","lname_required_message":"Last Name is required.","layout_columns":"2","required":"1","multiple_name":"true","fname_required":"1","lname_required":"1","fname_description":"Name will be used to match the Interac transaction"},{"id":"number-12","element_id":"number-12","form_id":"wrapper-5141-2604","parent_group":"","type":"number","options":[],"cols":"12","conditions":[{"element_id":"select-5","rule":"is","value":"Cash"}],"wrapper_id":"wrapper-5141-2604","hidden_behavior":"zero","calculations":"true","limit_min":"0","limit_max":"","field_label":"Additional donation?","placeholder":"","default_value":"0","precision":"2"},{"id":"select-6","element_id":"select-6","form_id":"wrapper-3349-9813","parent_group":"","type":"select","options":[{"label":"Yes","value":"Yes","limit":"","key":"9957-8245","error":"","calculation":"0","default":"1"},{"label":"No","value":"No","limit":"","key":"3891-9710","error":"","calculation":"1","default":""}],"cols":"12","conditions":[{"element_id":"select-5","rule":"is","value":"Credit Card"},{"element_id":"calculation-1","rule":"is_great","value":"9.99"}],"wrapper_id":"wrapper-3349-9813","hidden_behavior":"zero","value_type":"single","field_label":"Add 3.5% to cover credit card processing fee?","multiselect_style":"modern","options_bulk_editor":"Yes;Yes; 1\nNo;No; 0","calculations":"true","options_expanded":"1","description":"We lose 3.5% of the amount to credit card companies. Selecting \u2018Yes\u2019 ensures McGill Choral Society gets the full amount. This is optional, but we appreciate your generosity.","condition_action":"show"},{"id":"calculation-2","element_id":"calculation-2","form_id":"wrapper-8815-8465","parent_group":"","type":"calculation","options":[],"cols":"12","conditions":[{"element_id":"select-5","rule":"is","value":"Credit Card"}],"wrapper_id":"wrapper-8815-8465","hidden_behavior":"zero","field_label":"Credit card fees","prefix":"$","suffix":"CAD","formula":"max(({checkbox-1}*{number-1}+{checkbox-2}*{number-2}+{checkbox-3}*{number-3}+{checkbox-4}*{number-4}+{checkbox-5}*{number-5}+{checkbox-6}*{number-6}+{checkbox-7}*{number-7}+{checkbox-8}*{number-8}+{checkbox-9}*{number-9}+{checkbox-10}*{number-10}+{checkbox-11}*{number-11})*(abs(1-{select-6}))*0.035,0.3)-({select-6}*{select-5})"},{"id":"calculation-1","element_id":"calculation-1","form_id":"wrapper-4414-4975","parent_group":"","type":"calculation","options":[],"cols":"12","conditions":[],"wrapper_id":"wrapper-4414-4975","hidden_behavior":"zero","field_label":"Total amount","prefix":"$","suffix":"CAD","formula":"{checkbox-1}*{number-1}+{checkbox-2}*{number-2}+{checkbox-3}*{number-3}+{checkbox-4}*{number-4}+{checkbox-5}*{number-5}+{checkbox-6}*{number-6}+{checkbox-7}*{number-7}+{checkbox-8}*{number-8}+{checkbox-9}*{number-9}+{checkbox-10}*{number-10}+{checkbox-11}*{number-11}+{number-12}+{calculation-2}"},{"id":"hidden-2","element_id":"hidden-2","form_id":"wrapper-2745-2384","parent_group":"","type":"hidden","options":[],"cols":"12","conditions":[],"wrapper_id":"wrapper-2745-2384","field_label":"Submission Date","default_value":"date_dmy"},{"id":"hidden-3","element_id":"hidden-3","form_id":"wrapper-7833-4482","parent_group":"","type":"hidden","options":[],"cols":"12","conditions":[],"wrapper_id":"wrapper-7833-4482","field_label":"Submission Time","default_value":"submission_time"}],"settings":{"pagination-header":"nav","paginationData":{"pagination-header-design":"show","pagination-header":"nav"},"formName":"Fall 2025 Sales","version":"1.39.0","form-border-style":"dashed","form-padding":"","form-border":"","fields-style":"enclosed","field-image-size":"custom","validation":"on_submit","akismet-protection":"1","form-style":"default","form-substyle":"default","enable-ajax":"true","autoclose":"true","submission-indicator":"show","indicator-label":"Submitting...","cform-color-option":"theme","basic-field-image-size":"custom","basic-fields-style":"open","store_submissions":"1","form-type":"default","submission-behaviour":"behaviour-hide","thankyou-message":"Thank you for contacting us, we will be in touch shortly.","submitData":{"custom-submit-text":"Submit","custom-invalid-form-message":"Error: Your form is not valid, please fix the errors!","conditions":[],"condition_action":"hide"},"validation-inline":"1","form-expire":"no_expire","form-padding-top":"10","form-padding-right":"0","form-padding-bottom":"0","form-padding-left":"0","form-border-width":"2","form-border-radius":"10","cform-label-font-family":"Roboto","cform-label-custom-family":"","cform-label-font-size":"12","cform-label-font-weight":"bold","cform-title-font-family":"Roboto","cform-title-custom-family":"","cform-title-font-size":"45","cform-title-font-weight":"normal","cform-title-text-align":"left","cform-subtitle-font-family":"Roboto","cform-subtitle-custom-font":"","cform-subtitle-font-size":"18","cform-subtitle-font-weight":"normal","cform-subtitle-text-align":"left","cform-input-font-family":"Roboto","cform-input-custom-font":"","cform-input-font-size":"16","cform-input-font-weight":"normal","cform-radio-font-family":"Roboto","cform-radio-custom-font":"","cform-radio-font-size":"14","cform-radio-font-weight":"normal","cform-select-font-family":"Roboto","cform-select-custom-family":"","cform-select-font-size":"16","cform-select-font-weight":"normal","cform-multiselect-font-family":"Roboto","cform-multiselect-custom-font":"","cform-multiselect-font-size":"16","cform-multiselect-font-weight":"normal","cform-multiselect-tag-font-family":"Roboto","cform-multiselect-tag-custom-font":"","cform-multiselect-tag-font-size":"12","cform-multiselect-tag-font-weight":"medium","cform-dropdown-font-family":"Roboto","cform-dropdown-custom-font":"","cform-dropdown-font-size":"16","cform-dropdown-font-weight":"normal","cform-calendar-font-family":"Roboto","cform-calendar-custom-font":"","cform-calendar-font-size":"13","cform-calendar-font-weight":"normal","cform-button-font-family":"Roboto","cform-button-custom-font":"","cform-button-font-size":"14","cform-button-font-weight":"500","cform-timeline-font-family":"Roboto","cform-timeline-custom-font":"","cform-timeline-font-size":"12","cform-timeline-font-weight":"normal","cform-pagination-font-family":"","cform-pagination-custom-font":"","cform-pagination-font-size":"16","cform-pagination-font-weight":"normal","payment_require_ssl":"","submission-file":"delete","trigger_from":"builder","template_type":"preset","template_name":"Blank Form","form_name":"fall-2025-sales","form_status":"publish","sc_email_link":"1","sc_message":"<p>Your form has been saved as draft and a resume link has been generated so you can return to the form anytime within {retention_period} days from today. Copy and save the link or enter your email address below to have the link sent to your mail.<\/p><p>These fields weren't saved to your submission draft: Paypal, Stripe, Signature, Password, Captcha, and Upload. Kindly fill them out before submitting the form.<\/p>","notification_count":0,"previous_status":"publish","honeypot":"1","field-image-height":"70"},"client_id":null,"integration_conditions":[],"behaviors":[{"slug":"behavior-1234-4567","label":"Transaction submitted!","autoclose-time":"1","autoclose":"1","newtab":"sametab","thankyou-message":"<p style=\"text-align: center\">Transaction submitted!<\/p>","email-thankyou-message":"","manual-thankyou-message":"","submission-behaviour":"behaviour-thankyou","redirect-url":"","conditions":[]}],"notifications":[]},"status":"publish","version":"1.39.0"}

Thank you for any hint of what is wrong.