NSQL Data Type (From documentation):
MONEY (<currency column>) specifies that the value is a monetary amount and that the currency is specified by the column alias in parenthesis. The currency must also be part of the SELECT statement.
I think you posted to APM Community by mistake instead of the Clarity/PPM Community?: CA PPM
Please take a look at this example provided as a previous answer by Georgy :
Dollar Symbol in Custom Portlet
Retrieving data ...