counting only when an other field starts with a certain letter

[#1]

I want to count all the actions where the code starts with a P,

the P is followed by different numbers.

What is incorrect in my expression?

count(distinct if(match(project_actions_code,'P%'),action_id))

[alexandros17 · Accepted solution]

Match tells if P is contained in the string, use this expression instead:

count(distinct if(Index(project_actions_code,'P')=1,action_id, null()))

or

count({$ <project_actions_code={'P%'}>}  distinct action_id)

let me know

[#3]

The code starts with a P or an A followed by numbers.

I only want to count the actions where the code starts with a P, without regard wich numbers follow the P

[alexandros17]

Ok, what about the code I sent to you?

[#5]

Replace % by *

count({$ <project_actions_code={'P*'}>}  distinct action_id) is the most efficient,

set analysis is more efficient than if clauses,

cheers

[#6]

The first expression works!

The second one only gives me zero's.

It solved my problem, thanks!

[#7]

Unfortunatly the set analysis doesn't work, the if-analysis does work