2 of 2 people found this helpful
The more performant solution is to create a calculated field:
ATTR([Amount]) / 100000
And then set the default number format to add the L as a suffix.
Number calculations always outperform string manipulations. This is currently set up as row level, hence the ATTR. You may not need that when using your real data. You also may need to work around some issues regarding the difference of comma separation with US dollars.