Highlighted

Percentage Calculations

New Here ,
Aug 17, 2020

Copy link to clipboard

Copied

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.

TOPICS
Acrobat SDK and JavaScript, Comment review and collaborate PDF, Create PDFs, Edit and convert PDFs, How to

Views

35

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Percentage Calculations

New Here ,
Aug 17, 2020

Copy link to clipboard

Copied

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.

TOPICS
Acrobat SDK and JavaScript, Comment review and collaborate PDF, Create PDFs, Edit and convert PDFs, How to

Views

36

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Aug 17, 2020 0
Contributor ,
Aug 17, 2020

Copy link to clipboard

Copied

How are Total Hours and AmountHr formatted?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 17, 2020 0
New Here ,
Aug 17, 2020

Copy link to clipboard

Copied

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?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 17, 2020 0
Contributor ,
Aug 17, 2020

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 17, 2020 0
Adobe Community Professional ,
Aug 17, 2020

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 17, 2020 0
New Here ,
Aug 17, 2020

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 17, 2020 0