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 |
|
midpenntech
Posting Yak Master
137 Posts |
 Posted - 2008-08-12 : 11:56:56
|
| how would i take this string of code and add if < 0 then <###,###,###,###> or if > 0 ###,###,###,###=SUM(Fields!MileageRev.Value - Fields!Maintjobs.Value - Fields!GasOther.Value)-Fields!Month.Value |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-12 : 12:22:38
|
| just give the expression for format"###,###,###,###;<###,###,###,###>" |
 |
|
|
midpenntech
Posting Yak Master
137 Posts |
Posted - 2008-08-12 : 12:33:39
|
| that worked thank you so much. |
|
|
|
|
|
|
summing and changing format