Set analisys: sum with specific condition

[aisolomatin]

Good day!

Need your help.

I got some data:

I need to make expression for New_sum(Value) with condition:

- if there is only Subbranch "no_sub" in Branch, then we don't sum value. If there are other Subbranches, then we sum all of them.

[sunny_talwar · Accepted solution]

May be like this:

Sum({<Branch = {"=Count(DISTINCT Subbranch) = 1 and Subbranch = 'no_sub' "}>}Value)

My bad, you need this:

=Sum({<Branch = {"=Not(Count(DISTINCT Subbranch) = 1 and Subbranch = 'no_sub')"}>}Value)

[sunny_talwar]

Or this:

=Sum({<Branch = {"=Count(DISTINCT Subbranch) <> 1 or Subbranch <> 'no_sub' "}>}Value)

[aisolomatin]

Sunny, great! thank you!