Clarity PPM

Expand all | Collapse all

How do I use MONEY or Current in NSQL?

  • 1.  How do I use MONEY or Current in NSQL?

    Posted 03-23-2016 06:50 PM

    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.



  • 2.  Re: How do I use MONEY or Current in NSQL?

    Posted 03-23-2016 06:56 PM

    Hello,

    I think you posted to APM Community by mistake instead of the Clarity/PPM Community?: Clarity PPM



  • 3.  Re: How do I use MONEY or Current in NSQL?

    Posted 03-24-2016 12:03 PM

    Please take a look at this example provided as a previous answer by Georgy :

     

    Dollar Symbol in Custom Portlet