Show last 3 digits of enum list suggest values

[KerryIBCLC]

Hi All,

I have an enum column (Matched phone numbers) that displays a list of phone numbers using the suggest values from the expression:

SELECT(guestbook[Phone number], ([First name] = [_THISROW].[First name]))

I need the enum list to display only the last three digits of the phone numbers.

I'm unsure how to integrate right() into this expression to get the desired effect.

Thanks.

[Suvrutt_Gurjar · Accepted solution]

I think , if possible, it will be better approach to do this truncation of phone number at source table level (guestbook)  by adding a column such as [Phone Number Short] and then perform the SELECT() operation on that column.

[KerryIBCLC]

Thank you kindly.  That's now working perfectly.