You are viewing limited content. For full access, please sign in.

Question

Three decimal places for currency

Forms Version 10 Business Processes How To

Updated February 11, 2022

asked on February 10, 2022

I'm working on a form to calculate mileage reimbursements. The IRS Standard Mileage Rates frequently use three decimal places. For example the current mileage rate for 2022 is 58.5 cents per mile or .585. We are on Forms 10.4.5. Is there a way to format the currency field to allow 3 decimal places so we can calculate the true reimbursement amount? Of would using a numbers field be the easiest way around this problem?

0 0

Replies

replied on February 10, 2022

I'm not sure about 10.4.5, but with LF11 at least, you could use a Number field instead. The Number field allows you to specify how many decimal places are required.

0 0

replied on February 11, 2022

Yea you'll just have to use a number field to store the rate. You could even keep it hidden and still use currency for all the fields that display to the user.

0 0

replied on February 11, 2022

I have a mileage form I’ve used for years that does the IRS rate and I store the rate in a number field and only do currency for the calculated reimbursement amount. I’m on 10.2.1 currently. I also have rate load from a DB lookup based on the trip trip date so that a reimbursement showing a date last year automatically has last year’s rate, and one showing a date this year has this year’s rate. The trips are a collection so they can add multiple trips and it looks up the appropriate rate for each one.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked February 10, 2022
Updated February 11, 2022
422 views