topic Re: Expression surpress null value work in QV but not work in QS. in App Development

Expression surpress null value work in QV but not work in QS.

paulyeo11 — Thu, 28 Jul 2016 11:17:25 GMT

Hi All

I have below expression from Sunny working fine :-

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')

But when i use the same expression in QS , i am unable to surpress the null row. ( it work fine in QV )

Paul

Re: Expression surpress null value work in QV but not work in QS.

paulyeo11 — Thu, 28 Jul 2016 11:20:12 GMT

My QVF

Re: Expression surpress null value work in QV but not work in QS.

Anonymous — Thu, 28 Jul 2016 11:36:56 GMT

Your expressions for Company Pay and TERMS are setting a value of '' if the if condition is not met. Try setting them both them both to null() instead :

if((Sum(curren)+Sum(days3)+Sum(days6)+Sum(days9)+Sum(above12))<>0, COMPANY_PAY, null() )

if((Sum(curren)+Sum(days3)+Sum(days6)+Sum(days9)+Sum(above12))<>0, TERMS, null())

Re: Expression surpress null value work in QV but not work in QS.

paulyeo11 — Thu, 28 Jul 2016 11:58:49 GMT

Hi Bill

I set according to your instruction . But the row with null value from SEGMENT = Related Coy , still display there.

Paul

Re: Expression surpress null value work in QV but not work in QS.

Anonymous — Thu, 28 Jul 2016 12:30:12 GMT

I can't find the row you are referring to. Could you share a screen shot of it ?

Re: Expression surpress null value work in QV but not work in QS.

paulyeo11 — Thu, 28 Jul 2016 12:54:58 GMT

Hi Bill

notice that all the row shown are SEGMENT = Related Coy , The amount is null , how to surpress these row ?

Re: Expression surpress null value work in QV but not work in QS.

Anonymous — Thu, 28 Jul 2016 13:00:05 GMT

When you null do you mean nil, as in the value of 0.00 for Total W/O Related coy ?

Re: Expression surpress null value work in QV but not work in QS.

paulyeo11 — Thu, 28 Jul 2016 13:05:48 GMT

Hi Bill

You are right .

I am sorry , i still said zero value not nul .

Paul

Re: Expression surpress null value work in QV but not work in QS.

Anonymous — Thu, 28 Jul 2016 13:29:30 GMT

I suspect all your expressions have to be zero for the rows to be suppressed see attached

For Company Pay try this

if (

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 ,

if((Sum(curren)+Sum(days3)+Sum(days6)+Sum(days9)+Sum(above12))<>0, COMPANY_PAY, null() ) , null() )

and similar for TERMES

Re: Expression surpress null value work in QV but not work in QS.

paulyeo11 — Thu, 28 Jul 2016 19:23:54 GMT

Hi Bill

Thank a Lot.

Paul