Skip to main content
Participant
March 25, 2024
Question

Calculation formula help

  • March 25, 2024
  • 1 reply
  • 310 views

I am brand new to using Adobe forms and formulas. I have a column that will calculate a "project completed percentage" based on the "scheduled value" and "total completed" for each row. I need this form to be empty to pass on to others to fill out but when I have the "scheduled value" column empty there are all these errors that pop up for each row in the "completed percentage" column. How can I prevent the error pop up for each row when that row's schedule value is empty?

This topic has been closed for replies.

1 reply

Thom Parker
Community Expert
Community Expert
March 25, 2024

First, read this article:

https://www.pdfscripting.com/public/Value-Entered-Does-Not-Match-Format.cfm

 

The root of the issue is a divide by zero.   To fix the issue, write the calculation as a script that tests for a non-zero denominator before performing the calculation. 

 

 

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often