Skip to main content
B
bs46990252
Participant
September 20, 2018
Answered

Putting mileage rate into a calculation

  • September 20, 2018
  • 1 reply
  • 2000 views

Help! I'm doing a monthly mileage reimbursement form and need to know how to put the mileage rate 0.555 into the calculation so it will multiply # of miles by the 0.555 rate.

This topic has been closed for replies.
Correct answer try67

If you have a field which contains the rate then you don't need to hard-code it. Simply use the Simplified Field Notation option under the Calculate tab of the Amount field and enter this:

Miles * Rate

If you want to hard-code the value, change it to:

Miles * 0.555

1 reply

try67
Community Expert
try67Community Expert
Community Expert
September 20, 2018

A good place to start: https://acrobatusers.com/tutorials/how-to-do-not-so-simple-form-calculations

B
bs46990252Author
Participant
September 20, 2018

I'm sure that site is wonderful but it is not clear to me - I apologize, I am a beginner and this is the most difficult form I will need to deal with.

Maybe I can be more specific.

I have three columns - the first is called "Miles" the second is called "Rate" and the third is "Amount"

the rate is .555 and I want to multiple the miles * rate to get the Amount. Is there a way to put the rate of .555 into a code for this so the rate is a fixed amount?

Thank you so much for any help anyone can give me.

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
September 20, 2018

If you have a field which contains the rate then you don't need to hard-code it. Simply use the Simplified Field Notation option under the Calculate tab of the Amount field and enter this:

Miles * Rate

If you want to hard-code the value, change it to:

Miles * 0.555

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices