You are viewing limited content. For full access, please sign in.

Question

Question

Hidden fields being used in calculation (but they shouldn't be)

asked on April 19, 2018

I'm working on an expense claim form and am using field rules show certain sections that are applicable.

i.e.

The issue is that if an employee goes back into the "Build your form" tab and changes their response, the amount entered into the hidden field is still used in the calculation:

I have the field rule set up so that the field data will be ignored when the field/section/page is hidden:

Is there a way to fix this? I am using the formulas in the layout so that the answers show properly once the form is submitted (I've had issues with JavaScript calculations not showing up, plus it's easier to manage the calculations without a coding background).

0 0

Answer

SELECTED ANSWER
replied on April 19, 2018

Someone shared something similar to that that I was able to make it work. When a radio button is not checked then the box that you don't want to sum does not get summed. It goes something like this:

=ADD(SUM(all_your_inevitable_subms_here),IF(some_radio_button="Yes",SUM(the_subtotal_all_expenses),0))

1 0

Replies

replied on April 19, 2018

This was definitely made more complicated by the fact that I have more than Yes/No questions but I figured it out. Thank you Raul!

2 0
You are not allowed to follow up in this post.

Sign in to reply to this post.