2 Replies Latest reply: Aug 28, 2013 8:15 AM by test test RSS

    Why is this expression not working?

      I have the following expression.

       

      if([RecordType] <> 'ExPL' OR [RecordType] <> 'ExDE' OR [RecordType] <> 'ExFR',
      
      if(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000'  , '305500'  ,'51062'  , '50339', '10339', '11678', '101230'}>} [InvoiceNetValue]) > 1000000,
      Num(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000'  , '305500'  ,'51062'  , '50339', '10339', '11678', '101230'}>} [InvoiceNetValue])/1000,'#.##0M;-#.##0M'),
      Num(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000'  , '305500'  ,'51062'  , '50339', '10339', '11678', '101230'}>} [InvoiceNetValue])/1000,'#.##0K;-#.##0K'))
      
      ,0)
      

       

      First I want to make sure these 3 record types are excluded. Then I want to exclude the selected CustomerKeys.

       

      The middle part works. the right customers are excluded. But whe I add the [RecordType] filter the result stays the same.

        • Re: Why is this expression not working?
          Celambarasan Adhimulam

          try with this

           

          if(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000'  , '305500'  ,'51062'  , '50339', '10339', '11678', '101230'}, [RecordType] -={'ExPL', 'ExDE', 'ExFR'}>} [InvoiceNetValue]) > 1000000, 

          Num(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000'  , '305500'  ,'51062'  , '50339', '10339', '11678', '101230'},[RecordType] -={'ExPL', 'ExDE', 'ExFR'}>} [InvoiceNetValue])/1000,'#.##0M;-#.##0M'), 

          Num(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000'  , '305500'  ,'51062'  , '50339', '10339', '11678', '101230'},[RecordType] -={'ExPL', 'ExDE', 'ExFR'}>} [InvoiceNetValue])/1000,'#.##0K;-#.##0K'))

           

          Celambarasan