Hello all. I can't figure out why calculated value on one list(works in other lists) is not working. The fields in sharepoint are set as single line of text. I'm not getting results even in the simplest form i.e. column1 * column2. Any ideas?
Answer
Nintex Forms Calculated Value not working
+3Best answer by SimonMuntz
Hi,
You posted in the SharePoint section but the form provided was an Nintex for O365 form so I have moved the post to the correct category.
The formula in the Proposed Spread Toatal has 1 to many closing brackets ')'
Fix this and see if it resolves your issue.
Not sure why you were not seeing any errors in the browser console. I imported and published the form, opened it and this error appeared and told me what the issue was.
+23- Nintex Employee
Hi,
Is there anything special about this list like the way it was created for instance? Do you see any errors in the browser console when opening the form in a browser?
Do you see any errors if you do a fiddler trace when opening the form?
If this a new form or was it imported from somewhere else?
Is there anything special about this list like the way it was created for instance? Do you see any errors in the browser console when opening the form in a browser?
Do you see any errors if you do a fiddler trace when opening the form?
If this a new form or was it imported from somewhere else?
+3thanks Simon.
I don't see any error. I created another list from scratch have problem with calculated value on this one also. i have four calculated value fields in one form and when one works the other doesn't. Also shows #value on the fields that don't work.
+23- Nintex Employee
- Answer
Hi,
You posted in the SharePoint section but the form provided was an Nintex for O365 form so I have moved the post to the correct category.
The formula in the Proposed Spread Toatal has 1 to many closing brackets ')'
Fix this and see if it resolves your issue.
Not sure why you were not seeing any errors in the browser console. I imported and published the form, opened it and this error appeared and told me what the issue was.
+2Did you try what Simon suggested?
"The formula in the Proposed Spread Toatal has 1 to many closing brackets ')'"
+23- Nintex Employee
Did you look at all the errors in the console when you published the form?
Rules like proposedpayrate==""&&is_Edit_ModeIs_Display_Mode are not valid. It should be proposedpayrate==""&& is_Edit_Mode && Is_Display_Mode
Instead of proposedpayrate=="" try isnullorempty(proposedpayrate)
You have used the If() runtime function but only input 1 parameter but it takes 3.
You have used the not() runtime function in the middle of a function. It can only be used to surround a whole function to reverse its output.
Rules like proposedpayrate==""&&is_Edit_ModeIs_Display_Mode are not valid. It should be proposedpayrate==""&& is_Edit_Mode && Is_Display_Mode
Instead of proposedpayrate=="" try isnullorempty(proposedpayrate)
You have used the If() runtime function but only input 1 parameter but it takes 3.
You have used the not() runtime function in the middle of a function. It can only be used to surround a whole function to reverse its output.
New look Nintex University is HERE: https://learn.nintex.com
+23- Nintex Employee
If you add an operator where the blue arrow is in my pic and type the formula in and not cut and paste it will work.
I added a plus and got.
+23- Nintex Employee
Looks the same as your previous formula but just has references in place instead of hardcoded numbers.
Do you see any errors in the browser console when the form is opened in new mode?
Are you testing in Preview mode or actually publishing and testing?
Are all the references referencing named controls or do they reference list columns etc?
Do you see any errors in the browser console when the form is opened in new mode?
Are you testing in Preview mode or actually publishing and testing?
Are all the references referencing named controls or do they reference list columns etc?
+3The formula's referencing columuns and it works with any other formulas except this specific one and comes up 0 when i test with numbers above in the published form. there's 1 "synthanxerror" in edit and new mode
+23- Nintex Employee
You answered your own question.
Resolve the syntaxerror that you are seeing in the browser console.
Resolve the syntaxerror that you are seeing in the browser console.
+23- Nintex Employee
Remove rules and calculated value controls one by one until the error goes away and then you will know where it is coming from.
+3I deleted everything on the form and still I had the one synthax error. Any other formulas on this field work except this one. any ideas? thanks.
(column1 –(column2 * (1 + column3 /100) + column4 / 2000 + column5 / 2000 + .75 * column6 + .75 * column7)) / column1
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.