Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Thank you so much Sunny! I did not know, you can do this... That makes a lot of things easier
Have a nice Weekend.