Text Formatting

[MikeC]

I have an expression that uses a variable to compute a tax amount. The result I want is Number of Units X 20 cents each. So if there are 100 units the tax should be $20.

Since I’ll be using this in a couple different places, I’ve created a variable called TaxAmt, so if the 20% (or .2) ever changes I can change the variable and it will follow through everywhere.

The expression that I’m using is {Sum(Parcel.[Number Of Units]) * TaxAmt}

When I run the report I can’t control the text formatting of the field. The results I’m returning are correct, but I’d like a group separator and I’d like the decimal to be limited to 2 places. The number that I'm currently seeing on the report is formatted like 1500.80000 rather than 1,500.80. I have the text formatting set as it should be, but the field on the report isn't respecting the formatting.

Is there something different about using a variable that causes problems with text formatting? Every other field that I'm setting formatting on works fine except this one.

[Ivan]

Hello,

We couldn't reproduce this bug.
Can you please send us a sample report with data, which reproduces the issue?

Thank you.