format

[mauri0623]

Hello,

when I sum a variable called transaction I get $18,964,936. I want this number to be $18,964,935.59. This is because the people that use excel to obtain this sum they come up with $18,964,935.59 and not $18,964,936. So I am 42 cent short and I am being blamed.

Thank you!

-mauri

[PaigeMiller]

Probably, the result of $18,964,936. is formatted to have zero digits to the right of the decimal point. So you need to change the format on that variable to one that includes digits to the right of the decimal point. You could apply format DOLLAR18.2 to that variable to see the cents displayed.

[VDD]

Bruster's million.

wait until they find you are 1/2 cent short.

[Kurt_Bremser]

Apart from the fact that you only need to change the display format, you should tell those people you are working in data warehousing, not accounting. With 18 millions, cents are statistically insignificant and therefore irrelevant. The beancounters should stay with SAP.

[ballardw · Accepted solution]

---

@Kurt_Bremser wrote:

Apart from the fact that you only need to change the display format, you should tell those people you are working in data warehousing, not accounting. With 18 millions, cents are statistically insignificant and therefore irrelevant. The beancounters should stay with SAP.

---

Actually my approach would be to provide them with a text file of about 5 million more rows than Excel can handle and ask them to "sum that".

Make sure to include a number of decimal points for some value that they are likely to miss by using only 2 decimals.