Set Analysis: len() & right()

[mithunr40]

How to calculate the number of employees whose PHONE_NUMBER consists of 12 symbols and ends with number '8'. They given me the fields and functions to use in set analysis: EMPLOYEE_ID, PHONE_NUMBER, len(), right().

They want this expression in set analysis, we can't use logic in backend.

I have written an expression but in this only one function only working.

count({<PHONE_NUMBER={"=len(PHONE_NUMBER)=12"},PHONE_NUMBER={"=right(PHONE_NUMBER,1)='8'"}>}EMPLOYEE_ID)

Please help me to solve this problem.

Thank you.

[MayilVahanan · Accepted solution]

Hi

Try like below

=Count({<PHONE_NUMBER={"=Len(PHONE_NUMBER)=10 and Right(PHONE_NUMBER,1)=8"}>}DISTINCT EMPLOYEE_ID)

[mithunr40]

Thank you @MayilVahanan