Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Seems a simple question but can't find a discussion on it anywhere...How do I use OR in an expression.
I want to Express;
Sum({<
( [Site]={"Site1"},[Date]={"02/01/2017"},[Hour]={"13"} )
OR
( [Site]={"Site2"},[Date]={"01/01/2017"},[Hour]={"14"} )
OR
( [Site]={"Site3"},[Date]={"07/01/2017"},[Hour]={"16"} )
>} [Gross Sales])
This should produce;
Site | Date | Hour | Gross Sales |
---|---|---|---|
Site1 | 02/01/2017 | 13 | £100,000 |
Site2 | 01/01/2017 | 14 | £98,025 |
Site3 | 07/01/2017 | 16 | £90,245 |
The Idea being that these are the top 3 results from another expression and I want only see results relating to them in combination only.
Many thanks for any help.
May be this:
Sum({<[Site] = {"Site1"}, [Date] = {"02/01/2017"}, [Hour] = {"13"}>+<[Site] = {"Site2"}, [Date] = {"01/01/2017"}, [Hour] = {"14"}>+<[Site] = {"Site3"}, [Date] = {"07/01/2017"}, [Hour] = {"16"}>} [Gross Sales])
May be this:
Sum({<[Site] = {"Site1"}, [Date] = {"02/01/2017"}, [Hour] = {"13"}>+<[Site] = {"Site2"}, [Date] = {"01/01/2017"}, [Hour] = {"14"}>+<[Site] = {"Site3"}, [Date] = {"07/01/2017"}, [Hour] = {"16"}>} [Gross Sales])
OR is '+' in set analysis. Try like:
Sum({
<[Site]={"Site1"},[Date]={"02/01/2017"},[Hour]={"13"}>
+
<[Site]={"Site2"},[Date]={"01/01/2017"},[Hour]={"14"} >
+
<[Site]={"Site3"},[Date]={"07/01/2017"},[Hour]={"16"} >}
[Gross Sales])
Also note '< >'
That simple!
Thank you, couldn't find this anywhere.