5 Replies Latest reply: Sep 19, 2016 4:46 AM by Anushree Shetty

# How to remove/hide row when column 1 have -ve value

Hi All

Sunny have help me on below post :-

My Table column 1 expression :-

Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=181'} >}total_ar  * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))

My Table column 2 expression :-

If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=181'} >}total_ar  * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) <> 0,

Sum(if(L5M='-1',sales)))

I need to remove the 1 Column 180 days , those row with -ve value. meaning i need to remove last 4 row.

I try modify My Table column 2 expression :-

If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=181'} >}total_ar  * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) > 0,

Sum(if(L5M='-1',sales)))

But it does not work.

Paul

my qvw

• ###### Re: How to remove/hide row when column 1 have -ve value

You probably need the same if condition for your first expression:

If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=181'} >}total_ar  * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) > 0,

Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=181'} >}total_ar  * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)))

• ###### Re: How to remove/hide row when column 1 have -ve value

Hi sunny

Thank you very much it work.

Paul

• ###### Re: How to remove/hide row when column 1 have -ve value

Try sometthing like If(Expression >0, Expression)

• ###### Re: How to remove/hide row when column 1 have -ve value

Hi,

You could probably use the Dimension limits tab as in the attachment