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 |
|
gavakie
Posting Yak Master
221 Posts |
 Posted - 2007-10-23 : 16:51:34
|
| so i have a date set that spits out these numbers Store type Total Sales211 Cross Promotions NCL Tote Promo 2.0000211 Advertisements Exit Zero Ad 2.0000211 Cross Promotions Hotel Promo 556.0000211 Non Promotional 559662.6300IN my report i have to show whats marketed in total sales with is the things that dont say Non Promotional but in my reporting services it sums everything then i need to show walk in which is just non promotional stuff. then a total for both. I tried this in an expression but got errors. I wasnt sure if I could use an expresstion.I tried this but it sums everything still=IIF( Fields!Type.Value = "Non Promotional",Sum ( Fields!TotalSales.Value) = 0 , Sum(Fields!TotalSales.Value)) |
|
|
|
|
|
Help with building a report