Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
5 subscribers
Views
1763 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
104912 - no subject - Hello,\n\nIn one of my reports, I'm tryi
mjmallet
over 10 years ago
Hello,
In one of my reports, I'm trying to count the word "Yes" in a text Array and then take the count and multiply it with a number to get a total.
I'm not sure which functions to used, I tried a couple of different ones but not getting any results.
Thanks...
OriginalPostID-104912
Discussion posts and replies are publicly visible
0
colton.beck
Appian Employee
over 10 years ago
Try something like this:
=count(wherecontains("Yes",{Yes/No_Array}))
Hope this helps.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
colton.beck
Appian Employee
over 10 years ago
That will give you the count, which you can then use in arithmetic operations.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rayudua
over 10 years ago
Hope this helps, might be better ways as well
=count(intersection(apply(fn!exact,ri!array,"Yes"),{true}))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rayudua
over 10 years ago
Agree 1st option by Colton gives better performance.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mjmallet
over 10 years ago
Thank you! It works like a charm!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel