Set analysis not working properly

[Anonymous]

Hi all

I have this expression which i can't get to work properly,

Sum({<FrontLossFlag ={'*'} - {'1'}, DataSource = {'*'} - {'DPW' , 'DEX (DPW)' }>} Real)

If I remove either 'DPW' or 'DEX (DPW)', then it works. But not if both a left inside the expressions, then it return the value of zero, which isn't correct.

I can't seem to figure what I'm doing wrong? I've also tried inserting '[ DEX (DPW) ] ', however this doesn't return the correct value either.

I hope someone can help

Regards

Stefan

[Anonymous]

Hi Raju

I'm not sure what you mean by coping cell value?

[Nagaraju_KCS]

I feel May be text issue,

Take DataSource filed in list box, select DEX (DPW) 

Right click on a cell -> copy to clipboard -> copy cell value

and paste in your expression.

[Anonymous]

Still the same.

[#5]

Syntactically, I don't think you're doing anything wrong.  I think it must be a problem in your data or the implementation in your application.

Your syntax works fine for me on some sample data.

LOAD * INLINE [

    FrontLossFlag, DataSource, LossAmount

    1, DPW, 1

    1, ABC, 2

    1, DEX (DPW), 3

    1, DEX, 4

    1, XYZ, 5

    0, DPW, 6

    0, ABC, 7

    0, DEX (DPW), 8

    0, DEX, 9

    0, XYZ, 10

];