5 Replies Latest reply: Sep 13, 2016 7:49 AM by Yeo Poh sai

# How to add condition =  (SEGMENT <> 'Related Coy') , into my SET expression ?

Hi All

My Table 2 Expression is working fine from Sunny :-

Sum({<aging = {'>=180'}>}da3_total * Pick(Match(currenc, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))

I need to insert a new condition into above expression , Which is SEGMENT not equal to Related Company. which is look like below :-

(SEGMENT <> 'Related Coy', SEGMENT)

Sum((SEGMENT <> 'Related Coy'),{<aging = {'>=180'}>}da3_total * Pick(Match(currenc, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))

I try the above expression , it is not working , Hope some one can advise.

I expected Table 2 Total = 383,409

Paul

my qvw

• ###### Re: How to add condition =  (SEGMENT <> 'Related Coy') , into my SET expression ?

Perhaps this

Sum({<aging = {'>=180'},SEGMENT -= {'Related Coy'} >} da3_total  * Pick(Match(currenc, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))

• ###### Re: How to add condition =  (SEGMENT <> 'Related Coy') , into my SET expression ?

Hi All

Many thank , it work fine now.

Paul

• ###### Re: How to add condition =  (SEGMENT <> 'Related Coy') , into my SET expression ?

you Need to put the new Expression inside {<

try this:

Sum({<SEGMENT-={'Related Coy'},aging = {'>=180'}>}da3_total * Pick(Match(currenc, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))

• ###### Re: How to add condition =  (SEGMENT <> 'Related Coy') , into my SET expression ?

use -= instead of <> in Your Expression Sum({<SEGMENT -={ 'Related Coy'}.......