Question

Form SUM Function causing an error

Forms

Updated October 27, 2016

asked on October 24, 2016

Hi,

Our client is using LF 10.1 with Forms.

Please check out my table below. It populates 8 default rows from a DB under the Description column. My 2nd column contains radio buttons with numeric values assigned to each selection and Comments column is a multi-line field.

I am using the function =SUM(ProcurementRiskQuestionnaireTable.Risk) in Risk Total field (Single Line) to calculate the sum and based on the calculated value, the Risk Threshold field is displayed.

You have to select Yes in the Radio control before the table to display these three fields. They are hidden otherwise.

When approving, if I select project value to be over 40K and select Risks Risk total is caculated, Risk Threshold is displayed and the form submits without any issues but if I leave it as No and submit the form, the below error is generated.

I couldn't find a log of any sort in the event viewer. I don't think Table format being either Fixed number of Rows or Range of Rows is an issue as I have tried both.

If anyone has encountered a similar issue, please let me know how you fixed it.

Thanks,
Adarsh

0 0

Answer

SELECTED ANSWER

replied on October 24, 2016

I tried the below formula and it seems to be working.

=SUM(0,ProcurementRiskQuestionnaireTable.Risk)

Will do some more testing shortly.

Thanks,

Adarsh

0 0

Replies

replied on October 25, 2016

Had you tried assigning a Default Value of "0" as opposed to changing your formula in the Risk Total Field to determine if that was the field causing the issue?

0 0

replied on October 27, 2016

Hi Steve, thanks for your response.

I had tried default value as 1 but it had not worked. What I have noticed until this issue is that form fields which are hidden don't influence the form (ex: a required field which is hidden). And just assumed that to be the case in this situation too. I may be wrong as I'm still learning how to use the form.

I was able to fix the issue when I tried what I responded with.

Thanks again,

Adarsh

0 0

You are not allowed to follow up in this post.

Question

Question

Form SUM Function causing an error

Answer

Replies

Sign in to reply to this post.