Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to create a set analysis expression which as OR conditions and AND condition(s).
in general it looks:
(Condition 1 OR Condition 2 OR Condition 3) AND Condition 4 AND Condition 5.
Any ideas how to accomplish this?
Thanks in Advance!
Dafnis
OR -> +
AND -> *
In general,
Sum({<Set1>+<Set2>} Amt)
Sum({<Set1>*<Set2>} Amt)
So for your case, might be like:
Sum({(<Condition 1> + <Condition 2> + <Condition 3>) * <Condition 4> * <Condition 5>} Field)
OR -> +
AND -> *
In general,
Sum({<Set1>+<Set2>} Amt)
Sum({<Set1>*<Set2>} Amt)
So for your case, might be like:
Sum({(<Condition 1> + <Condition 2> + <Condition 3>) * <Condition 4> * <Condition 5>} Field)
Great! Thanks!
BTW, is it possible to use a variable for the above expression?
Yes.
Is there a way to have current selection AND bookmark?
Say I have a bookmark called 'BASELINE'
I tried {BASELINE+1} but that does not appear to work.
Nor does {<BASELINE>+<1>}
Any other ideas?
Current selection is referred by '$'. So try like: {$+Bookmark}