Showing results for 
Search instead for 
Did you mean: 

Supress not reqd data

Former Member
0 Kudos

Hi experts

I have a cross tab which is getting data for the colleges and the uiniversities and turnovers.

but i am getting all 0s with value in one or 2 cells.

Any ideas hw can i suppress them?

Thanks in advance.


View Entire Topic
Former Member
0 Kudos


If you put

currentfieldvalue = 0

to suppress the 0s, it would display blank cells.

Rather what you can do, right click on the summary value field ->Common tab -> Click on X-2 for Display string and put the below formula

if currentfieldvalue = 0 then "No data for here"

else "" {summaryfield};

This would display "No data for here" instead of 0s or blank cells and data where they are present.

Hope this helps!!