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
@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.
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.
Bruster's million.
wait until they find you are 1/2 cent short.
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.
@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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: