repeating field update problem

[jsutherlin]

I have three repeating fields. The first is a dollar value, the second is a looked up value that gives you the choice of Yes or No (indicating taxable or not), and the third is the calculated tax. The third field calculates the tax properly but only once. If the tax field is changed from yes to no or vica versa the tax field will not change value. It only changes if the pre-calculated value is deleted prior to changing the yes or no tax field. The value fields are stored as numbers. Anyone know how to make the tax field recalculate whenever the yes/no field is changed. Thanks!

 

[ImStevenB]

When you set up the calculated field, what formula did you use for the calculation?

I setup a test file that used three fields - Value, Taxable and CalcTotal. In the calculated field I used a Case equation

Case (Taxable = "Yes", Value * 1.06, Value)

This equation will also work using If.

HTH Im Steven B

http://www.myarcadia.net

 

[jsutherlin]

Here is the calculation I used:

If( LineItemTaxable = "No",0, Line Items Cost*Tax rate)

It's stored as a number with the options: Auto enter Calculation,Repeating.

It will calculate properly once but once there is a calculated value in the field it won't be changed when the yes/no answer is changed.

???

Thanks,
Jim

 

[ImStevenB]

I suspect that the field type you have now is Number.

Reset the field type to calculation;

-Go to Define Fields
-Select the field name
-Change the field type to Calculation
-Click on Save (it will tell you that you will lose the
information already stored there - click OK)
-When presented with the calculation screen enter the
calculation you were using before
-Set the repeating field value at the lower left corner

That's it. Now it will update as you change the value.

HTH
Im Steven B

http://www.myarcadia.net

 

[jsutherlin]

That works...sort of. Now the value changes when the yes/no is changed but only the first one in the repeating field. All of the others "below" stay at 0 no matter what the yes/no is.

 

[ImStevenB]

Here is my e-mail

stevenb@nvc.net

Send me an e-mail and I'll send you the sample file I created. Check the field settings I have.

If you can't get the field to work correctly, you may want to delete it then re-create it. Im Steven B

http://www.myarcadia.net