I have been searching all over and I cannot figure this out. I am creating and almost done with a form that will calculate the currency conversion rate for Foreign Lodging Receipts. Basically I need to be able to show how much the lodging is per night in U.S. Dollars. We use the Total Foreign Currency on the receipt / Total U.S. Dollars charged on the credit card statement. There are some times, when we need to round a nightly rate up or down by a cent in order to equal the Total U.S. Dollars charged on the statement.
For example, $270.11 was charged on the credit card. The individual stayed only 2 nights. $270.11 / 2 = $135.055 per night. However, I need my Livecycle Table Calculation comes to $135.06 per night and shows the Total Lodging as $270.11. But I need it to round one night to $135.05. Otherwise, the credit card will be overpaid by 1 cent.
I can send or upload the form, however I do not see where i can upload.
(270.11 / 2).toFixed(2) Will give you "135.06" as a string. If you need it as a number try +(270.11 / 2).toFixed(2) ... with a plus in front or Number((270.11 / 2).toFixed(2))
Math.round((270.11 / 2) * 100) / 100 will also do it and faster but to my eye looks clumsy.
Hi Jessica, You have to upload the file to any file sharing site, Google docs, Dropbox, etc. Then you can post a link here. You should be able to replace the numbers with references to your fields. Bruce