I'm building a calculator where people can figure out how much in taxes they would own on their home in Connecticut under a new tax rate. I'm usisng the submission form datapage wizard for this.

I have a dropdown for selecting a town, where I used a lookup table where the display is the town name and the value is the mill rate, which is in an adjacent column in the table. I tested this with a calculated field to just [@field:town] and in the preview it outputs as a the correct mill rate.

The next part of the form is a text field where the user enters their home value for example $300,000.

Then I have another calculated field which is [@field:homevalue]*[@field:town]/1000

Caspio tells me this is a valid formula, however, when I go to preview i get a "calculation error" message.

You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

## Question

## richs

I'm building a calculator where people can figure out how much in taxes they would own on their home in Connecticut under a new tax rate. I'm usisng the submission form datapage wizard for this.

I have a dropdown for selecting a town, where I used a lookup table where the display is the town name and the value is the mill rate, which is in an adjacent column in the table. I tested this with a calculated field to just [@field:town] and in the preview it outputs as a the correct mill rate.

The next part of the form is a text field where the user enters their home value for example $300,000.

Then I have another calculated field which is [@field:homevalue]*[@field:town]/1000

Caspio tells me this is a valid formula, however, when I go to preview i get a "calculation error" message.

## Link to comment

## Share on other sites

## 4 answers to this question

## Recommended Posts

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Note:Your post will require moderator approval before it will be visible.