Text Format
Posted: Fri Dec 19, 2014 10:08 am
Hi
I have an expression along the lines of:
The TextFormat in Properties is set to Number, with Decimal Digits set to 2. However, it doesn't round to 2 Decimal Digits, it returns values like 0.35645664 instead of 0.36.
I know I can use the expression below instead, but why does the TextFormat option not display this to 2 Decimal Digits?
Thanks,
Rick.
I have an expression along the lines of:
Code: Select all
{
(sum(a)
/
((x+y+x)/
((x==0?0:1)+(y==0?0:1)+(z==0?0:1))
)
)
}I know I can use the expression below instead, but why does the TextFormat option not display this to 2 Decimal Digits?
Code: Select all
{Format("{0:N2}",
(sum(a)
/
((x+y+x)/
((x==0?0:1)+(y==0?0:1)+(z==0?0:1))
)
)
)}Rick.