Calculate the number of employees whose last letter of FIRST_NAME is 'a'.

[Sree_1]

Hi,

Can someone help me with calculating number of employees whose last letter of FIRST_NAME is 'a'.

TIA

[rwunderlich · Accepted solution]

Count({<FIRST_NAME={"*a"}>}Distinct Employee)

-Rob

[Sree_1]

Hi Rob,

Thanks for the solution. Can you please give one more set expression using the right() function?

Thank you,

Sree

[rwunderlich]

In what case would you want to use the right function? 

-Rob

[BrunPierre]

I take it that you want an alternative using Right(), then perhaps as below.

=Count({$<FIRST_NAME= {"=Right(FIRST_NAME, 1) = 'a'"}>}DISTINCT Employee)