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

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

    Yeo Poh sai

      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