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-06-09 : 12:38:55
|
| Total has positive and neg numbers.I guess under the WHERE statement I should say equip1.total <1 'equip1.total*-1'is that correct or how close am i. |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2008-06-09 : 13:00:23
|
| We need more data to answer your question about whether you should only sum all values as positive, but to make all the values positive use sum(abs(total))Jim |
 |
|
|
midpenntech
Posting Yak Master
137 Posts |
Posted - 2008-06-09 : 13:20:29
|
| That worked I just edited it and placed it under the Layout tab. Thanks! |
|
|
|
midpenntech
Posting Yak Master
137 Posts |
Posted - 2008-06-09 : 13:38:46
|
| that worked to sum the income but now the income also has negs (trying to sum the income as well. here is the code I used but its not adding summing the negs its actually adding them to the total.This code works I just need it to take the negs out and so I can sum it. if that makes any sence.=sum(abs(Fields!Total.Value))-IIF(Fields!eqprecdt.Value< #6/1/2007#,Fields!bookvalue.Value* 0.07,Fields!bookvalue.Value* 0.07 * -1 * datediff("d",#5/31/2008#,Fields!eqprecdt.Value)/365) |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-06-09 : 15:46:11
|
quote:
Originally posted by midpenntech
that worked to sum the income but now the income also has negs (trying to sum the income as well. here is the code I used but its not adding summing the negs its actually adding them to the total.This code works I just need it to take the negs out and so I can sum it. if that makes any sence.=sum(abs(Fields!Total.Value))-IIF(Fields!eqprecdt.Value< #6/1/2007#,Fields!bookvalue.Value* 0.07,Fields!bookvalue.Value* 0.07 * -1 * datediff("d",#5/31/2008#,Fields!eqprecdt.Value)/365)
Are you trying to create formula in SSRS? Then you should post this in Reporting Services forumMadhivananFailing to plan is Planning to fail |
|
|
|
midpenntech
Posting Yak Master
137 Posts |
Posted - 2008-06-09 : 16:09:36
|
| yes still having an issue with it. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-10 : 00:55:50
|
quote:
Originally posted by midpenntech
yes still having an issue with it.
Which is field that designates the income? or is it that the expression you posted calculates income? If thats the case i cant see where you're summing it?? |
|
|
|
|
|
|
simple question about total