Hi there,

I am still new at LaserFiche and forms in general. I am playing around with calculations and noticed an issue while trying to find the total cost of mileage based on our per mile rate.

For the total cost variable (field type is currency), I have =MULT(Vehicle.Mileage,Vehicle.Rate) which is calling out the appropriate number fields from the Vehicle table. I set the Rate as a number for field type with a default value of 0.58. The mileage is going to be user input and I also have it as a number field type.

When I do the cost using the line above, I get "This field contains a calculation error. References: Mileage, Rate." 

When I create three separate number fields outside the table and use the following line, it multiplies just fine. I used =MULT(Rate1,Mileage) for the cost variable.

Is there something I am doing wrong (being a noob at this, I am totally okay with this) or is it a glitch that I have to use CSS or JavaScript to fix? Please let me know if I need to provide any screenshots for clarity.

I am going to Empower next month and take as many Forms classes as I can to learn more, but figured I would dive into it a little and get an understanding of it.

Thanks for the assistance.

Remy