Is it possible to make a calculated value control work on a hidden field? I am working on a mileage reimbursement form and I need to calculate the number of miles based on a field that I would like to hide.
The first number of miles field is a text field where if the user selects "other" in either of their location boxes, they have to manually enter the number of miles. The second number of miles field is a calculated value that pulls in the number of miles from a list based off of our locations, and it changes depending on if the user selects round trip or one way. The hidden field calculates based off of what the users select in the location fields and it tells the calculated miles field what column to pull from on the list.