Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I insert an or condition?
SUM({<S_Artikel.ypA_Flag_DER -= {1}, S_Artikel.SNRArt = {190,200,205} OR S_Artikel.xc_ArtikelTyp = {'Geräte'}>ypA_RBT_Posting.Amount)
Like:
if(([S_Artikel.xc_ArtikelTyp] = 'Geräte' and [S_Artikel.ypA_Flag_DER] <> 1) or match([S_Artikel.SNRArt], 190, 200, 205), Value, null())
So condition A if permanent, and then either one of B or C also need to happen then,
try this:
Sum({<ConditionA={A},ConditionB={B}>+<ConditionA={A},ConditionC={C}>}Amount)
Just saw your expression:-
That expression will work upto the point where one of the condition B or C are met, when both will get satisfied and then also you need output your expression wont work.
I can try too:
SUM({<ConditionA = {A}, ConditionB = {B}, ConditionC -= {C}> + <ConditionA = {A}, ConditionB -= {B}, ConditionC = {C}>}Amount)
It is important that condition B and condition C are each excluded (-=) so that the values are not included twice. But it definitely works that way.
Not able to understand the question properly as Field names and order in you both logic is little bit confusing to me.
Let me try
Suppose your Requirement is that either Condition A or Condition B needs to satisfied in set analysis for Sum,
then try this:
Sum({ < Condition A > + < Condition B > }Amount)
Hello, thank you for your answer. Your guess is correct.
I'm trying to simplify it:
Condition A must be met. Additionally condition B OR C.
SUM({<ConditionA = {A}, ConditionB = {B} OR ConditionC = {C}>}Amount)
But how can I use an OR condition?
1.) SUM({<ConditionA = {A}, ConditionB = {B} + ConditionC = {C}>}Amount) - doesn't work
2.) SUM({<ConditionA = {A}, ConditionB = {B}, ConditionC = {C}>}Amount) - is an AND-Condition
3.) SUM({<ConditionA = {A}, ConditionB = {B} OR ConditionC = {C}>}Amount) - doesn't work
I don't know 😞
Oh man I have the solution. I probably just thought too much...
SUM({<ConditionA = {A}, ConditionB = {B}, ConditionC -= {C}>}Amount)
+
SUM({<ConditionA = {A}, ConditionB -= {B}, ConditionC = {C}>}Amount)
So condition A if permanent, and then either one of B or C also need to happen then,
try this:
Sum({<ConditionA={A},ConditionB={B}>+<ConditionA={A},ConditionC={C}>}Amount)
Just saw your expression:-
That expression will work upto the point where one of the condition B or C are met, when both will get satisfied and then also you need output your expression wont work.
I can try too:
SUM({<ConditionA = {A}, ConditionB = {B}, ConditionC -= {C}> + <ConditionA = {A}, ConditionB -= {B}, ConditionC = {C}>}Amount)
It is important that condition B and condition C are each excluded (-=) so that the values are not included twice. But it definitely works that way.