Display Specific Number of Values in Report
We are maintaing GL Account of 9 Digit. The requirement is to display the first 3 of last 5 digit.
Ex- GL Acc-123456789, the report should show 567.
Is it possible to do this using offset, also note that it is not necessary that user will give GL Acc in the selection. So, the user might provide or might not provider the GL Acc while running the report.
So, in either case report should always display the first 3 of last 5 digit.