7 Replies Latest reply: Jul 28, 2016 6:54 AM by saima siddiqui

# My Table Top 3 row value are null How to suppress ?

Hi All

I have the expression with the help from sunny it working fine :-

'S\$ ' &Num(

sum({<SEGMENT -= {'Related Coy'}>}

If( US_Cust='USD', 1.3,

If( US_Cust='RP', 0.0001,

if( US_Cust='EU',1.5, 1)))* days3)

+ sum({<SEGMENT -= {'Related Coy'}>}

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1))) * days6)

+ sum({<SEGMENT -= {'Related Coy'}>}

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1))) * days9)

+ sum({<SEGMENT -= {'Related Coy'}>}

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1)))*above12)

+ sum({<SEGMENT -= {'Related Coy'}>}

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1))) * curren)

,'###,##0.00')

Now the Top 3 row Segment = Related Coy , the Amount is zero.

Now my question is how to hide those row with zero value ?

Hope some one can share with me.

Paul

my QVW

• ###### Re: My Table Top 3 row value are null How to suppress ?

Hi

Supress Zero Values under Presentation tab

• ###### Re: My Table Top 3 row value are null How to suppress ?

Hi

In the presentation tab-> suppression zero value just enable it.It will hide the zero rows

• ###### Re: My Table Top 3 row value are null How to suppress ?

Hi All

I am unable to find the supress zero in presentation tab . Kindly send me a screen shot. I am using Ver 9

• ###### Re: My Table Top 3 row value are null How to suppress ?

Hi

=

sum({<SEGMENT -= {'Related Coy'}>}

If( US_Cust='USD', 1.3,

If( US_Cust='RP', 0.0001,

if( US_Cust='EU',1.5, 1)))* days3)

+ sum({<SEGMENT -= {'Related Coy'}>}

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1))) * days6)

+ sum({<SEGMENT -= {'Related Coy'}>}

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1))) * days9)

+ sum({<SEGMENT -= {'Related Coy'}>}

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1)))*above12)

+ sum({<SEGMENT -= {'Related Coy'}>}

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1))) * curren)

and then set the number format to money.. and then suppress null values from presenattion tab

Please find attached the screenshot of number format and suppress null values

• ###### Re: My Table Top 3 row value are null How to suppress ?

Try this:

Only({<SEGMENT -= {'Related Coy'}>} 'S\$ ') &

Num(

sum({<SEGMENT -= {'Related Coy'}>}

If( US_Cust='USD', 1.3,

If( US_Cust='RP', 0.0001,

if( US_Cust='EU',1.5, 1)))* days3)

+ sum({<SEGMENT -= {'Related Coy'}>}

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1))) * days6)

+ sum({<SEGMENT -= {'Related Coy'}>}

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1))) * days9)

+ sum({<SEGMENT -= {'Related Coy'}>}

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1)))*above12)

+ sum({<SEGMENT -= {'Related Coy'}>}

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1))) * curren)

,'###,##0.00')

• ###### Re: My Table Top 3 row value are null How to suppress ?

Hi Sunny

it work fine now .

Thank you very much.

Paul