Question

Invalid formula expression

Forms Version 10

Updated December 29, 2016

asked on December 29, 2016

I am working on quite a large form, when filling out the form all calculations work as expected. However when you submit I am getting errors like below. I have tried removing the formula and using just static numbers in the field but I just get the same error on the next SUM formula. Is there another way to sum a column of a table? We are on Version 10.1.0.642.

0 0

Replies

replied on December 29, 2016

Hi CJ

The Structure of your Formula looks good. I also tested this on the same version of Forms you have and it worked fine. example =SUM(SampleTable.Distance_Tot).

Have you created a test form and tested this outside your form to see if it works. In a few cases where I've seen these types of issues where it works in a test environment, I've tried deleting the "Field" and the "Variable", saving and refreshing the form, and then create it again.

0 0

replied on December 29, 2016

A simple test form works okay. This form took about 3 weeks to build with all the database tables, javascript, css, etc. Rebuilding these items would be awful. Is there another option to try summing these?

0 0

View 1 previous reply

replied on December 29, 2016 • Show version history

If you understand XML, you can download your form and see if there are any errors in the XML. You could sum the table using JS instead of the built in calculations.

0 0

replied on December 29, 2016

I don't see any issue in the XML:

<formula>
    <expression>=SUM(Section_Exterior.Allowed)</expression>
    <parsedExpression>LF.f.SUM(LF.f._CNUMBER(26))</parsedExpression>
    <order>35</order>
    <triggerFields xmlns:d7p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d7p1:int>26</d7p1:int>
    </triggerFields>
    <populatedField>32</populatedField>
    <datasetOperands xmlns:d7p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" />
    <errorType>none</errorType>
    <disableOnReadonly>false</disableOnReadonly>
</formula>

FieldID 26 and 32 are correct, and there is no weird formatting. Guess I'll have to redo all 79 formulas with JS...

0 0

replied on December 29, 2016

i'd try importing the XML to a new process, and if that doesn't work, open a ticket with support before redoing all those lines of code. If you want to attach the XML here maybe some here can look at it to see if there is anything we can see.

0 0

replied on December 29, 2016

Please open a support case with your reseller by providing the exported process. Attach the xml here may not be a good idea as it may contain SID of your windows account.

0 0

You are not allowed to follow up in this post.

Question

Question

Invalid formula expression

Replies

Sign in to reply to this post.