We have created a Form for a client where we are performing some calculations to procure a Gross Amount based on a set of fields being selected. The calculation includes fields that can be hidden based on a set of radio buttons. When we try and submit the Form, we get the below error:
Laserfiche Forms has encountered a problem.
Errors encountered during forms submission:
Field Name: Total Allocated Invoice Amount, Position: 58, Error: An unexpected error has occurred. [LFF502-UnexpectedError] [LFF1018-ErrorOccuredDuringFormulaCalculation]
Your form data has been saved. Please click the "Recover form" button to go back to your form to fix any errors and try to submit again. You will be sent to a sign-in page first if your session was disconnected.
The calculation is below:
=IF(AND(Coding_Type.PO,Additional_GL_Coding_PO_Checkbox.Additional_GL_Coding),SUM(Total_PO_Amount,Total_GL_Amount),IF(AND(Coding_Type="AFE Multi-line",Additional_GL_Coding_AFE_Checkbox.Additional_GL_Coding),SUM(Total_M_AFE_Amount,Total_GL_Amount),IF(AND(Coding_Type.PO),SUM(Total_PO_Amount),IF(AND(Coding_Type.AFE),SUM(Total_S_AFE_Amount),IF(AND(Coding_Type.GL),SUM(Total_GL_Amount),IF(AND(Coding_Type="AFE Multi-line"),SUM(Total_M_AFE_Amount),""))))))
The help files do not include any information about Error 1018.
Any help would be greatly appreciated!
Thank you!
Molly