Percentage Calculations

Forum|Forum|5 years ago
August 17, 2020
2 replies
933 views

Hello. I'm trying to have two fields in Acrobat automatically calculate based off two other fields filled in by the employee for our employee bill back form.

The employee will fill in the field Total Hours and the field AmountHr (amount per hour). I then need the field named Bill Back Monies NMI to calculate what 25% of Total Hours*Amount/Hr is, and another field called Total Bill Back Monies Emp to calculate what 75% is. I know this sounds simple, but I've never written formulas/script in Acrobat.

This topic has been closed for replies.

Bernd Alheit

Community Expert

You can use the simplified notation.
E.g. Total\ Hours * AMOUNTHR * 0.25

B

Brandy5EA9Author

Participant

Thank you. That worked. I was trying to use the last option and kept getting errors. And the 2nd option with the presets wouldn't let me select fields unless it was all of them. I appreciate your help.

A

Asim123

Inspiring

How are Total Hours and AmountHr formatted?

B

Brandy5EA9Author

Participant

Total Hours is formatted as a number with 2 decimal places and Amount/HR is formatted the same way, but shows the $ sign. I need the field Bill Back Monies NMI to perform this calculation (Total Hours*Amount/Hr)*0.25 and the field Bill Back Monies Emp to perform this calculation (Total Hours*Amount/Hr)*0.75. And both Bill Back Monies fields need to be formated the same as the Amount/Hr field. Does this make sense?

A

Asim123

Inspiring

You described solution for your problem 🙂

Like Bernd said use Simplified field notation in calculation fields, if you have field names with spaces use \ instead of space.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded