I'm writing a form on which I want to display a bunch of currency figures (aged payables and receivables) without the dollar sign or any decimals. That is $421,187.16 should display as 421,187 with no decimal. I'm retrieving the values with SELECT and placing them into static text labels using PROPERTY CAPTION. . .
I figured the easiest way would be to change the CURRENCY setting to have no decimals (SET CURR ' ' PREF 0 B), but this has the effect of retrieving the whole number and shifting the decimal to places, multiplying all the numbers by 100. So far, the best I can find is (ROUND(FLOAT(CurrColumn, 0))). Has anyone done this before? -- Larry
