we can use
this is for 1,234.00 format
this is for 1234.00 format
=Format(Fields!Number.Value, "0.00")this is for 1234.00 format
- Proposed as answer by Kiran Cherupally Thursday, March 18, 2010 1:27 PM
please elaborate further if you still need help on the issue. if your field is in float or decimal, and you need to show it in 2 decimal place, there are a lot of other format style you could use, depending on how you wants it. For example:
Iam not for sure if Decimal.Round works in C# or C++. I know it works in Visual Basic 2005 and 2008 in my own experience with it.
Yes, it does work though.
In C++ you can use setprecision(numberofdecimalplaces)
Note the above in c++ is only for output not variables
I realize this thread is a bit old, but I have a closely related question. How do you get a number to round to two decimal places, only when there are decimals to begin with?
In other words, I want 8.56789 to appear as 8.57
...but I also want 8 to appear as 8 (not as 8.00)
I also agree with Arun and Rajesh,
When I need to specify the number of decimal points as part of an expression, e.g. ; - Tooltip series properties of a chart.
I use; -
I hope this helps someone.
If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI,MCC, PGD SoftDev (Open), MBCS http://www.innovativebusinessintelligence.com/ http://uk.linkedin.com/in/kieranpatrickwood