Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can someone help me with calculating number of employees whose last letter of FIRST_NAME is 'a'.
TIA
Count({<FIRST_NAME={"*a"}>}Distinct Employee)
-Rob
Hi Rob,
Thanks for the solution. Can you please give one more set expression using the right() function?
Thank you,
Sree
In what case would you want to use the right function?
-Rob
I take it that you want an alternative using Right(), then perhaps as below.
=Count({$<FIRST_NAME= {"=Right(FIRST_NAME, 1) = 'a'"}>}DISTINCT Employee)