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...

Discussion posts and replies are publicly visible

Parents

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

Reply

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

Children

No Data