Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Worked perfectly. Thanks mate!