[mapguide-users] Expression - format float to decimal with 2 decimal places

2013-03-11 Thread Gunter Becker
Hi, formatting a number to a decimal with 2 decimal places could be solved by using Round(myPropery,2) So, 31.456 gives 31.46 But when myProperty is an integer then I would like to have for example 30.00. But the expression engine always returns just 30 without the 2 decimal places. How can I

Re: [mapguide-users] Expression - format float to decimal with 2 decimal places

2013-03-11 Thread Ryan Northcott
You tried tried Round (x,0) I have this solution for long integers ill re-write it when I get in my office - sent via mobile iOS5 On 2013-03-11, at 7:21 AM, Gunter Becker gunter.bec...@csogis.de wrote: Hi, formatting a number to a decimal with 2 decimal places could be solved by using

Re: [mapguide-users] Expression - format float to decimal with 2 decimal places

2013-03-11 Thread Gunter Becker
Ryan, thanks for your reply. I think you misunderstood my problem. I don't want to strip of the decimal places. Instead I do want to have 2 digital places. My problem is that I have already a float (ex 30.0) and the expression engine automatically strips of the decimal places. But I would

Re: [mapguide-users] Expression - format float to decimal with 2 decimal places

2013-03-11 Thread Ryan Northcott
Ahh.. Then that's a Masking,/Padding you want then, and not a Rounding Math function. Rounding 12.000 to 12 is correct no matter how many decimal places you ask for. 12.1 will probably go to 12.1 as well I know with a couple steps of logic you could probably use INSTR() and RPAD to test for