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 |
|
v_kash
Starting Member
45 Posts |
 Posted - 2009-06-22 : 11:25:01
|
| hello - i have a question. hope this makes sense. within my report - i have a column called act min, and avg min. avg is basically the calls act min/date counter. However, if the person doesn't work that day, i dont want to do a running total for that day.ex: if i dont work on 5/1/09, the actual minutes = 0. if i work on 5/4/09 and my actual minutes is 176.7, i want the avg minutes to start off as 176.7. right now, my report displays 88.35. anyone have any ideas? |
|
|
v_kash
Starting Member
45 Posts |
Posted - 2009-06-22 : 11:29:12
|
| fyi - i only want to do a running total for days that they actually worked (where the actual min > 0). |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-22 : 11:50:11
|
| what you can do is to use a expression inside running value function to replace actual fieldname with something likeIIF (Fields!YourField.name =0, Nothing,Fields!YourField.name) |
|
|
|
|
|
|
RUNNING TOTAL QUESTION