First, I may already have my answer/the best solution. We are using Forms 10.2.1, but have 10.4 installed on our test environment. This issue exists in 10.2.1, but not in 10.4. The solution may be as simple just needing to update, but I wanted to put out the question in case there may be something I can do until we are ready to upgrade.
We have a process where the initiator lists a number of transactions that they want to dispute:
At the next step, we add a column to the table and the processor chooses yes or no for each transaction, indicating if we have charge back rights. I then have two different currency fields summing the values depending on the result of the Yes/No question.
The Write Off Amount field uses this formula:
=SUMIF(Disputed_Transaction_Details.CB_Rights,"No",Disputed_Transaction_Details.Amount)
The Charge Back Amount field uses this formula:
=SUMIF(Disputed_Transaction_Details.CB_Rights,"Yes",Disputed_Transaction_Details.Amount)
In general this works without any problems. Sometimes there are times where the processor needs to remove a transaction from the dispute for various reasons. If a row is removed, the fields still total correctly when the form is being fill out, but we get an error upon clicking submit. (There is a lengthier, more detailed version of the error that I can post if desired.)
'=SUMIF(Disputed_Transactions_Details_Repeated.CB_Rights,"No",Disputed_Transactions_Details_Repeated.Amount)' is an invalid formula expression. [LFF1000-InvalidExpression]
Or:
'=SUMIF(Disputed_Transactions_Details_Repeated.CB_Rights,"Yes",Disputed_Transactions_Details_Repeated.Amount)' is an invalid formula expression. [LFF1000-InvalidExpression]
This error occurs if it is a mixture of yes/no as well as exclusively yes or exclusively no. It also occurs if we have a default answer chosen to yes or no and the row is removed.
If no rows are removed, the form can be submitted without any problems and moves to the next step just fine.
If there is anything that I can adjust with our system and/or the formula expression, I would appreciate it. Otherwise, I'll just remove the auto sum from those fields and they will total it by hand until we are ready for 10.4.
Thanks!