Text Format

[rswans]

Hi

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

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?

Code: Select all

 {Format("{0:N2}",
(sum(a)
/
((x+y+x)/
((x==0?0:1)+(y==0?0:1)+(z==0?0:1))
)
)
)}

Thanks,
Rick.

[HighAley]

Hello.

What version of our product do you use?
Could you send us a sample report template which reproduces the issue?

Thank you.