Jump to content
  • 0

Calculation error despite valid formula



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

  • 0

Hello @richs,

I believe you may have this problem because [@field:town] is the text value. You may get the value of the Mill_rate from your lookup table with the following formula so it will be the Number type:
SELECT [@field:Mill_rate] FROM Town_lookup WHERE Town=target.[@field:Town]
And then you can have another calculated value which is [@field:House_value]*[@field:Mill_rate]/1000
Just change the names of the fields to yours. 

Hope this helps!

Link to comment
Share on other sites

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.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...