mibuso.com

Hi all,

I'm sometimes stumbling in the different forums over the same question about how to extract the decimal places of a decimal value.
There are some good solutions but if you take a closer look at the format function itself then you are getting a pretty nice solution for most of your request.

1) Extracting the decimal places of a decimal value for display purposes:
Try this: MESSAGE( '%1', COPYSTR( FORMAT( 1234.5, 0, '<Precision,2:><Decimals>'), 2) );

You have to use "<Precision,..." because otherwise you will get a blank string if the decimal places are 0!
Use "2:" to get at least 2 decimal places up to infinite decimal places. If you want to get allways 2 decimal places use "2:2"

2) Extracting the integer value of a decimal value for display purposes
Try this: MESSAGE( '%1', FORMAT( 1234.5, 0, '<Integer>') );

Just a little hint, I hope someone can use.



...Manfred