Skip to main content
Participant
November 28, 2023
Answered

What am I doing wrong? Acrobat form with formula

  • November 28, 2023
  • 2 replies
  • 993 views

I have tried everything I've found online to try and get one simple formula to work on the attached form, but I'm not having any luck. The Revenues Over (Under) Expenditures line in the 2nd and 3rd columns should be the sum of the Total Support/Revenues minus the sum of the Total Expenses/Expenditures. All my other formulas on this page appear to work, but I can't get this one to work. I've been doing this in the Simplified Field Notation under the Calculate tab and nothing works. What am I doing wrong? Any and all help would be greatly appreciated!

Correct answer Nesa Nurani

Simplified field notation doesn't work well with fields that include dots in their names (spaces too).

Try to enter like this:

Text10\.21\.0-Text9\.13\.0\.0

2 replies

Participant
January 5, 2025

 

It sounds like you’re facing a challenge with getting the formula for "Revenues Over (Under) Expenditures" to work properly. From what you've described, you want to subtract the total expenses from total revenues in your formula, but the issue seems to be with how it's being entered.

When using the Simplified Field Notation under the Calculate tab, ensure that the field names you’re referencing are correctly typed, as even a small typo can cause issues. Also, if you’re summing values from different fields, make sure to use the correct syntax for adding and subtracting those fields.

Here’s an example of a basic formula for calculating revenues over expenditures:

 

mathematica
Code
{Total Support/Revenues} - {Total Expenses/Expenditures}
 

If the above doesn’t work, try checking if there are any hidden characters or spaces in your field names, or review the field settings to ensure everything is set up correctly.

On a related note, if you ever need a simple and accurate way to calculate net salaries or deductions, check out nettotasca.it. It’s an online net salary calculator that simplifies complex calculations, and it may help you with similar tasks in the future!

Hope this helps, and feel free to share more details if the issue persists!

Nesa Nurani
Community Expert
Nesa NuraniCommunity ExpertCorrect answer
Community Expert
November 28, 2023

Simplified field notation doesn't work well with fields that include dots in their names (spaces too).

Try to enter like this:

Text10\.21\.0-Text9\.13\.0\.0

SheliaHCAuthor
Participant
November 28, 2023

Thanks so much for your help. Telling me that it doesn't like all the dots in the names helped immensely. I just changed the field names and the formula works now!!  

 

Again, thanks so much!!!