Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
osirisa
Constraint Violating Yak Guru
289 Posts |
 Posted - 2008-03-11 : 11:44:42
|
| Hi Group:I need help with the following the first one is the Expression for the Column that give all the results as a percentage. I need two things: 1. That if the number for that percentage is negative ---- I need this number in parentesis example (-25) 2. If is negative I also want the number and the parenthesis in red. Expresion for the Text Box=Round((Fields!Deliveries.Value-Fields!Net_Receipts.Value)/Fields!Deliveries.Value*100,2)Properties for the Text Box=CDec(Fields!Deliveries.Value -Fields!Net_Receipts.Value /Fields!Deliveries.Value)Thanks for the help |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2008-03-11 : 15:00:37
|
| Thank You jsmith8858 :) Deeply appreciate it.. :) |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
|
|
|
Need -Parenthesis and Color for negative numbers.