Expression using OR

[Anonymous]

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.

[sunny_talwar · Accepted solution]

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])

[tresesco]

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 '< >'

[Anonymous]

That simple!

Thank you, couldn't find this anywhere.