Set analysis for two conditions

[Anonymous]

Hi team,

Need one help with respect to Set analysis

In My expression i have a set analysis string  =Sum({<BU2-={'Total'}>}comparision_AR)

I want to merge another =Sum({<BURGN-={'Total'}>}comparision_AR)

could you pls help how to merge this two string and put it in a single?

Thanks in advance

Deepak

[sunny_talwar]

May be this:

And condition

=Sum({<BU2-={'Total'}, BURGN-={'Total'}>}comparision_AR)

or

or condition

=Sum({<BU2-={'Total'}>+<BURGN-={'Total'}>}comparision_AR)

[Anonymous]

Big Thanks! Sunny, The second condition works perfectly!

Regards

Deepak

[Angela_Zhou]

And condition can also using the binary operation (*), which is very usefully especially when you need mix conditions of AND, OR, and etc.

=Sum({<BU2-={'Total'}>*<BURGN-={'Total'}>} comparision_AR)