Hi
We have a report studio that a long gone user setup. I've attached a screen shot of the setup of the report. We want to apply a filter that shows us the rows where there were no sales last year, but sales this year. Zero suppression is removing all those where there is nothing. If we apply a filter on the end column (a tuple showing Last Year, Net Value) for anything that is 0 but NOT NULL, the nulls still show. Does anyone have any thoughts about what I may be doing wrong, of how we can get this to work?
Thanks
We have a report studio that a long gone user setup. I've attached a screen shot of the setup of the report. We want to apply a filter that shows us the rows where there were no sales last year, but sales this year. Zero suppression is removing all those where there is nothing. If we apply a filter on the end column (a tuple showing Last Year, Net Value) for anything that is 0 but NOT NULL, the nulls still show. Does anyone have any thoughts about what I may be doing wrong, of how we can get this to work?
Thanks