Text Formatting
Posted: Fri Jun 18, 2010 2:51 pm
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.
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.