Currency Rounding on Adobe Forms

[dean_hinson2]

Hello,

I have an issue with a currency field NOT rounding on an Adobe Form.  I reviewed the discussion on Quantity Rounding and it did not help.  I have a currency field in the Binding tab with Data Format: Float.In the Field tab, the Display and Edit Pattern is ZZZ,ZZ9.

So why is this not allowing rounding?

Regards, Dean.

[dean_hinson2 · Accepted solution]

Hello All,

I think I found the issue and an OSS Message need to opened to SAP. I found an OSS note Note 1431760 - Statistical value rounded incorrectly in print form. It lead me to the routine ROUND_STATISTICAL_VALUES. The code does not round to the nearest whole number for US.

However, per US Regulations...

15 CFR Part 30

1. 30.6

(17) Value. In general, the value to be reported in the EEI shall be the value of the goods at the U.S. port of export. The value shall be the selling price as defined in this paragraph (or the cost if the goods are not sold), including inland or domestic freight, insurance, and other charges to the U.S. seaport, airport, or land border port of export. Cost of goods is the sum of expenses incurred in the USPPI acquisition or production of the goods. Report the value to the nearest

dollar; omit cents. Fractions of a dollar less than 50 cents should be ignored, and fractions of 50 cents or more should be rounded up to the next dollar.

So, I have opened an OSS Message to SAP.

Thank you for all of your replies.

[jayan_abap]

Hi Dean,

There is  a method in javacript which can be used to round a number.

Ex. Round(<<number>>, <<digits_after_decimal>>)

[former_member189727]

Hi,

Why not write a JavaScript as mentioned in below link:

http://stackoverflow.com/questions/246193/how-do-i-round-a-number-in-javascript

http://www.w3schools.com/jsref/jsref_round.asp

Other Options

Math.floor	Rounds downward to the nearest integer (e.g. 1.7 becomes 1.0).
Math.ceil	Rounds upward to the nearest integer (e.g. 1.3 becomes 2.0).

Regards,

Sathya.

[Former Member]

Hi Dean,

I assume you are trying to round the value up to 0 decimal places.

Try this pattern.

num{z,zzz,zzz,zz9}

FYI

http://help.adobe.com/en_US/livecycle/9.0/designerHelp/index.htm?content=000490.html

regards,

Xiang Li