cancel
Showing results for 
Search instead for 
Did you mean: 

How to suppress zero values for summary in Cross Tab

Former Member
0 Kudos
180

Hi

I have a cross tab with Country as Column, Region as Row and Last year Sales as summary field.

The cross tab is displaying all zeros for those regions, which are not part of the country.

For example for Country Argentina, Region Abu Dhabi is displaying $0.00 (sum of last year sales) as it is not a region belonging to Argentina.

Any suggestions would be appreciated.

Thanks in advance.

Regards

Sourashree

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member260594
Active Contributor
0 Kudos

Use the display string formatting option. If CurrentFieldValue = 0 then ' ' else totext(CurrentFieldValue)

Former Member
0 Kudos

Graham I tried your method but when I entered


If CurrentFieldValue = 0 
then ' ' 
else 
totext(CurrentFieldValue);

it says Boolean is required??

Regards

Jehanzeb

Former Member
0 Kudos

Hi Sourashree,

I guess we're on the same boat here ;-).

Anyhow I think what you can do is, suppress the value of rows if it is 0.

Like this

This needs to be entered in Suppress Formula Code

Currentfieldvalue=0;

Regards

Jehanzeb

Former Member
0 Kudos

HI

Thanks for the quick reply.

I have tried that already, however it doesnot help.

Regards

Sourashree

Former Member
0 Kudos

did you try to form the cross tab and check surpress empty rows, empty colums?