How to perform calculations in an adobe interactive form

Similar to excel, we specify the condition as being greater than, less than, or equal to a particular value. Lastly, we define the results. The true result is the value that will be displayed if the condition is met.

This field will determine whether or not an order counts as bulk. Considering these conditions, we have the formula:. Then, we set our condition, which is that TQ must be greater than It would then be considered a bulk order, and generate the following result:.

There are cases where you may want to have multiple conditions met instead of just one. Fortunately, there is a way to create a conditional field that generates values based on multiple conditions.

We would have the following field:. As you can see, we defined two variables on two separate lines. Take note that the final value is also a calculation that takes into account the discount. One important consideration you should make is the calculation order. Unlike Excel, which renders calculations simultaneously, Acrobat relies on the user to determine which formulas come first.

Make sure to review the calculation order before publishing your form. Use Google Fonts in Word. Use FaceTime on Android Signal vs. Customize the Taskbar in Windows What Is svchost. Best Smartwatches. Best Gaming Laptops.

Best Smart Displays. Best Home Security Systems. Best External Solid State Drives. Best Portable Chargers. Best Phone Chargers. Best Wi-Fi Range Extenders. Important Note: For all examples going forward, only the expression will be shown, the complete syntax for the text tag will not be shown. See Supported Operators for a list of the operators supported within expressions. Existing fields within a document can be used to define an expression by referring to the field by its name.

The result of the multiplication of the values of these two fields will be populated in the Calculated Field. If a field name contains a space, the field name must be placed within a square bracket [] to be able to reference it in an expression. Expressions can also include one or more functions from the Adobe Sign list of supported functions.

The specified functions get evaluated during the agreement signing process and the resulting value gets displayed in the calculated field. See Supported Functions for a list of functions supported within expressions.

Compares two values and returns true if the two values are equal and false if they are not. Not Equals. Compares two values and returns true if the two values are not equal and false if they are. Less Than. Compares two values and returns Boolean true or false if the first value is less than the second value. Greater than or Equals.

Compares two values and returns Boolean true or false if the first value is greater than or equal to the second value. Less Than or Equals. Compares two values and returns Boolean true or false if the first value is less than or equal to the second value. Greater than. Compares two values and returns Boolean true or false if the first value is greater than the second value. Returns the part of the date specified by the first argument as an integer. See Accepted Values for Portions of Dates below for information on the acceptable values for part attribute.

Adds the specified number of parts e. You may use numbers or field names. For example: dateAdd "m", "Jan 1, ", 3 would return a date of Apr 1, In this example, the formula adds 3 months to the date specified. Returns the number of parts e. For example: dateDiff "d", "Jan 1, ", "Jan 2, " would return a value of 1 to represent 1 day between January 1st and January 2nd.

Returns the number of days contained in the part e. Return the date and time when the formula was evaluated, most often when the e-sign page is loaded. Returns true if any of the logical arguments logical1, logical2, Evaluates a source field "return value" used in dropboxes and radio buttons to populate a default value into the calculated field, based on a list of possible values.

If no match is found, it would return None. The following values can be used in date related functions when specifying the portion of the date on which the function should operate. In addition to specifying the expression for a calculated field the output value can also be formatted. The output can be formatted as text the default or formatted as a number or a date. Specifies the type of value the calculated field represents.

Accepted values for this parameter are: number and date. The following characters can be used to specify the formatting of an output in the form of a number. Places a dollar sign or locale-appropriate symbol before formatted number.

When specified it must be the first character for the format string. The following characters can be used to specify the formatting of an output in the form of a date. Calculated fields can be specified through the Adobe Sign authoring environment. The steps below will guide you through the steps of defining a calculated field once you are in the authoring environment. Drag-and-drop a field in the document. Double click on the field that you just added to bring up the field properties dialog.

Give the field an appropriate name. Change the Value Type attribute using the drop-down list to be of type Calculated Value. For example: summing up a total on an invoice sheet to give to a customer. Below are the steps used to setup the calculation function within a PDF document. Adding Calculations to Forms Open the document that you wish to add calculations to Make sure you are in the Form Field editing mode.

Make sure that you have correctly named all of the Form Fields in your document to make it easier to setup the calculations Select the Text Field that you would like to perform the calculation and open up the Text Field Properties. This can be done by either double clicking on the field, or right clicking and selecting Properties.