SET Analysis with OR?

[#1]

Hi,

i would like to build a SET Analysis with a 'OR':

=SUM({$<YEAR = {"$(=max(YEAR-1))"},MONTH = {"<=$(=max(MONTH))"}, Group={$(=vRA)}>} $(vREV))

We have a Group of customers but i want to add ONE other customer (He is not part of the Group.

Is this possible?

Many Thx

Christoph

[vgutkovsky · Accepted solution]

Christoph,

The + sign is the OR operator in set analysis. So, for example: sum({<Group={$(=vRA)}>+<CustomerID={"123456"}>} $(vRev))

Regards,

[martin59]

Hi,

You can try that :

=SUM({$<YEAR = {"$(=max(YEAR-1))"},MONTH = {"<=$(=max(MONTH))"}>*(<Group={$(=vRA)}>+<Customer={XX}>)} $(vREV))

Hope that helps you.