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

[paulyeo11]

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

[paulyeo11]

my qvw

[Anonymous]

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

[stabben23]

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

[Anil_Babu_Samineni · Accepted solution]

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

[paulyeo11]

Hi All

Many thank , it work fine now.

Paul