To find the sum containing a particular word

[#1]

Hi

Greetings.

I need to find the sum of a group of values based on a certain word.The word can be either at the beginning/middle/at the end & it can be on upper and lower case too.In some cases the word will not be even present but they can be inside the same column header from the datasource(Excel its here -always)

Please find attached the sample data..

I want to find the sum of Quantity.

I tried using the following set expression

=sum({$<Assembly={"Display","DISPLAY","display"}>}[Quantity])

But it results in zero.

Kindly help in this regard

Regards

Senthil ! !

[MK_QSL]

You can do below trick...

create another DummyDisply field in script..

Load

  *,

  UPPER(Display) as DummyDisplay

Inline

[

  Display, Quantity

  Broken Display, 14

  Dust in Display, 15

  Impurities in Display, 22

  Broken, 12

];

Now use below set analysis function

=SUM({<DummyDisplay = {'*DISPLAY*'}>}Quantity)