Set Analysis Problem

[max_potass]

Hi everyone,

I am in a state of complete resignation... I have no Idea what I am doing wrong. I did this before and it worked just fine, so I guess I did something wrong, but I can't figure it out on myself...

I have following Expression:

SUM({[1]<Rep_HaWa_Normal={'Nicht HaWa, Nicht REP'}, Verkaufsorganisation={'1000'}, [Leading Product Cluster TEXT_PMM]={'X'}>}AE.Netto)

I now want AE.Netto for Not [Leading Product Cluster TEXT_PMM]={'Food Solutions'} so I do this:

SUM({[1]<Rep_HaWa_Normal={'Nicht HaWa, Nicht REP'}, Verkaufsorganisation={'1000'}> - [1]<[Leading Product Cluster TEXT_PMM]={'X'}>}AE.Netto)

But it Returns 0. That implies, that there are only 'X' for [Leading Product Cluster TEXT_PMM], right? But it is not the case. If I just do not filter [Leading Product Cluster TEXT_PMM] it get the correct value...

No Idea what is going on. I have this logic working in several different spots and no problems...

Best Regards

Max

[sunny_talwar · Accepted solution]

Why don't you try this

SUM({[1]<Rep_HaWa_Normal={'Nicht HaWa, Nicht REP'}, Verkaufsorganisation={'1000'}, [Leading Product Cluster TEXT_PMM] -= {'X'}>} AE.Netto)

[max_potass]

Thank you so much Sunny! I did not know, you can do this... That makes a lot of things easier

Have a nice Weekend.