766
SELECT GL00103.PRCNTAGE AS "Distribution %"
This statement is returning a value of $14.34 when, it should show up as either 14.34 or 14.34%.
The "$", will confuse the end user.
I am able to make it work in SQL server, but Smartlist Builder SQL Script is throwing in that pesky dollar sign.
Any tips?
*This post is locked for comments
The awesome thing is, there's more than one way to do things, whether in GP or with the help of a little SQL. Glad you were able to get through.
To display % symbol, open the Smartlist Builder window from Microsoft Dynamics GP>> Tools>> Smartlist Builder>> Smartlist Builder. Select the field in scrolling window and click the arrow button next to Display Name. In the set Field Options window, check on the Show Percentage Symbol. Save the changes.
Share
Report
All responses (
Answers (
