Trying to get a calculation to take the data in one field and depending on what it is adding the information to a total field. there are multiple lines in this document. | Community
Skip to main content
L
LindaCade
October 18, 2018
Solved

Trying to get a calculation to take the data in one field and depending on what it is adding the information to a total field. there are multiple lines in this document.

  • October 18, 2018
  • 1 reply
  • 971 views

I am trying to get a sumif statement to work in three different fields.  The data is located in two separate fields in the form.  Rate and Miles.  There are 31 lines on this form that can contain data in these fields that needs to be included in the appropriate field below:

  1. If “Rate” = S add to Standard (S) Miles Take
    information in corresponding line in field MILES and add to Line 34 TOTAL
    STANDARD MILES
  2. If “Rate” = F add to Fleet (F) Miles Take information
    in corresponding line in field MILES and add to Line  Line 35 TOTAL FLEEET MILES
  3. If “Rate” = R add to Rental( R) Miles Take information
    in corresponding line in field MILES and add to Line  Line 36 TOTAL RENTAL MILES
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Mayank_Gandhi

Hi Linda,

You might have to iterate across the fields and based on the 'Rate' field value trigger the if else condition in the loop itself. Something like Trying to convert a SUMIF formula from Excel to Acrobat DC form (javascript)

1 reply

Mayank_Gandhi
Adobe Employee
Mayank_GandhiAdobe EmployeeAccepted solution
Adobe Employee
November 13, 2018

Hi Linda,

You might have to iterate across the fields and based on the 'Rate' field value trigger the if else condition in the loop itself. Something like Trying to convert a SUMIF formula from Excel to Acrobat DC form (javascript)

Terms & ConditionsAccessibility statement

Loading footer...