Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be this
Count(DISTINCT {<App = {"=Len(Trim(Group)) > 0 and Group1 = Group2"}>}App)
May be this
Count(DISTINCT {<App = {"=Len(Trim(Group)) > 0 and Group1 = Group2"}>}App)
Thanks Sunny!