Re: [DUG]: Currency Formats

[Nello Sestini]

Mark   I want both formats to ROUND the same way - rather than the different ways that they do at present.  If the 3rd decimal place is anything but 5 there is no problem - both methods round correctly.   LOL - i suppose being "consistent" by printing the wrong thing in both places isn't quite satisfactory   I think the following will work assuming the value of the expression is always >= 0   if "x" is the QR expression you have now - change it to:   int( ( x*100 +0.5)) / 100   (and put back the label the way you had it <g>     if x can be < 0 then you'll need to fix this up to test the sign of x and either add or subtracts the .5   something like   int( ( x*100 + if(x<0,-0.5,0.5))) / 100   I haven't actually checked these so caveat emptor.   Hope I haven't done something stupid.   -ns