I would like to know how do I extract last 4 or 5 digits from Inv no column,
below is my recent expression that I’m fetching Inv no from,
CONCATENATE( SELECT ([Related MANAGERs][INV NO], [LOCAL LR] = [_THISROW].[LOCAL LR]),", ")
I know I’ve to use Right() expression,but I’m confused as to where should I apply it.
A little help is much Appreciated.