count with multiple conditions based on list box

[felipe_oliveira]

App	Group1	Group2
0001	A	A
0002	B	B
0003	A	B
0004	C	C
0005		A
0006	B	A
...	...	...

List Box (Group2)
A
B
C

Hi masters! I am trying to create a count if with multiple conditions having one of those conditions based on the selected field of the list box.

The conditions should be as following:

vSelectedField = GetFieldSelections(Group2,',')

Group1 <> ''    (not blank)

Group1 = Group2

Group1 = $(=vSelectedField)

something like this:

=count({1<Group1 -= {''}, Group1 = p(Group2), Group1=$(=vSelectedField)}>}App)

Thanks!

[sunny_talwar · Accepted solution]

May be this

Count(DISTINCT {<App = {"=Len(Trim(Group)) > 0 and Group1 = Group2"}>}App)

[felipe_oliveira]

Thanks Sunny!