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
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
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
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