Skip to main content
B
Byanca5C3B
Known Participant
February 2, 2022
Question

Error when dividing two formulas

  • February 2, 2022
  • 2 replies
  • 1023 views

I have summed boxes in one text box (text 13), and other boxes in another area (text 14). When I try to divide the first sum text box by the second sum text box I get an error in my t. See attached file.

 

 

This topic has been closed for replies.

2 replies

Bernd Alheit
Community Expert
Bernd AlheitCommunity Expert
Community Expert
February 2, 2022

I can't see any calculation in the form.

B
Byanca5C3BAuthor
Known Participant
February 10, 2022

It says the value entered does not match the format of the field, it seems to be because I am dividing by zero, but it is a fill in so it will be zero until something is put in. I've attached the formulas.

Bernd Alheit
Community Expert
Bernd AlheitCommunity Expert
Community Expert
February 10, 2022

With a script you can avoid the message.

T
Test Screen Name
Legend
February 2, 2022

Please show, or tell, us the exact error message. I don't see an error, but I don't know where to look. 

 

Remember not to divide by zero - you must check this first.

B
Byanca5C3BAuthor
Known Participant
February 10, 2022

It says the value entered does not match the format of the field, it seems to be because I am dividing by zero, but it is a fill in so it will be zero until something is put in. I've attached the formulas.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices