You are viewing limited content. For full access, please sign in.

Question

Question

Calculation Error in Collection using built in Calulator

Updated October 11, 2016
asked on October 11, 2016

I have the following formula in one filed in a collection,  =MULT(INDEX(Requested_Item_s__1.QtyNew,ROW()),INDEX(Requested_Item_s__1.UnitPriceNew,ROW())).

I hide this collection in a form when specific condition is set before this so users don't have to enter anything in the required fields to calculate these values.

 

When this section is hidden and if I submit the Form, I am getting an error.  Please see the attached error.  If I remove this formula then the Form works fine.  I am using Laserfiche Forms Version 10.1.0.619.

 

Thanks!

 

Forms Error.png
Forms Error.png (8.34 KB)
Download
0 0

Replies

replied on October 11, 2016

Ran into a similar issue on a build we were doing.  It appears as though hiding a section of a form handles the 'required' elements just fine but are calculations in the hidden section are still attempted.  Our solution was to ensure that any fields that our calculations depended on, had default values of zero (0). In our specific scenario this allowed the calculation to occur without error and with no negative impact to our final calculation value.

1 0
replied on October 11, 2016

Thanks!  did the same thing but when you add a default field then the user has to clear it before entering a new value.  Hope LF can fix this

0 0
replied on October 11, 2016

We are aware of this behavior and there are various SCRs filed for specific cases of handling as different Calculation functions should treat different fields differently. These are targeted to be addressed in Forms 11.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Attachments
Related Posts
Loading ...