Question

Currency field with formula cannot be empty when submitting the form.

Forms

Updated March 13, 2018

asked on March 12, 2018 • Show version history

Hi guys, i am working on a form and i found out whenever i click the submit button,"This field contains a calculation error" will be shown and i cannot proceed further.

the field that has the issue consist of "DIV" formula which will divide the value from the left 2 fields.

i've tried putting a default value in the field but it's still show as empty when the form loaded. if leave it empty and the error comes out.

any workaround or i miss something here?

thanks in advance.

Jeff

1.png (9.85 KB)

| Download

2.png (6.48 KB)

| Download

0 0

Replies

replied on March 13, 2018

That should make it easier than. You can do something like this, where div1 and div2 are your variable names.:

=IF(div2=0,"div1",div1/div2)

1 0

replied on March 12, 2018 • Show version history

I think that even if you set them to zero, you are going to get errors because you can't divide anything by zero. Maybe if you add a condition to check that divisor is not zero or something.

Try this: Where "Table is your table variable and div1 and div2 are your first and second boxes.

=IF(INDEX(Table.div2,row()=0),”INDEX(Table.div1,row())”,INDEX(Table.div1,row())/INDEX(Table.div2,row()))

div.PNG (3.16 KB)

| Download

0 0

replied on March 12, 2018

Exactly, we can't divide anything by zero, i am no using a table currently but i will try that, thanks for your reply!

0 0

You are not allowed to follow up in this post.

Question

Question

Currency field with formula cannot be empty when submitting the form.

Replies

Sign in to reply to this post.