
Anonymous
Not applicable
2016-10-26
04:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set analysis for two conditions
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
6,450 Views
3 Replies

MVP
2016-10-26
12:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this:
And condition
=Sum({<BU2-={'Total'}, BURGN-={'Total'}>}comparision_AR)
or
or condition
=Sum({<BU2-={'Total'}>+<BURGN-={'Total'}>}comparision_AR)

Anonymous
Not applicable
2016-10-27
04:21 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Big Thanks! Sunny, The second condition works perfectly!
Regards
Deepak
5,542 Views

Contributor III
2019-04-07
10:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
Angela Z.
5,257 Views
