Skip to main content
Known Participant
Feb 2, 2022 6:30 AM UTC
Question

Error when dividing two formulas

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 is closed to new replies. Start a new post to keep the conversation going.

7 replies

Bernd Alheit
Community Expert
Community Expert
Feb 2, 2022 12:10 PM UTC

I can't see any calculation in the form.

Translate
Known Participant
Feb 10, 2022 8:02 AM UTC

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.

Translate
Bernd Alheit
Community Expert
Community Expert
Feb 10, 2022 9:24 AM UTC

With a script you can avoid the message.

Translate
Legend
Feb 2, 2022 9:07 AM UTC

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.

Translate
Known Participant
Feb 10, 2022 8:01 AM UTC

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.

Translate