Analysis report: "if any column Not Zero" is not filtering

lili14

Hello all,

When using the Analysis report the option "if any column Not Zero" is not filtering when exporting to EXCEL. I tried adding the following code to the report "Export Analysis Rep. to Excel (7113)":

AnalysisLine.SETFILTER(Show,'<>%1',AnalysisLine.Show::"If Any Column Not Zero");

But when I use SETFILTER I don't get any lines anymore(with or without values). any thoughts?

Thanks,

aseigle

If I'm not mistaken we came across this several months ago and found a KB article from Microsoft to resolve this. I don't have it handy, but you can search the KnowledgeBase for it.