15 Replies Latest reply: Dec 27, 2017 8:48 AM by omar bensalem RSS

    Number format

    omar bensalem

      Hi folks,

       

      I'm trying to format my numbers in the SCRIPT.

       

      here's how they're now:

      Capture.PNG

       

      and I want them to be as follow:

      Capture.PNG

       

      For that, I've done as follow:

      num(Current_Notional,'# ##0') as Current_Notional,


      and

      num(num#(Current_Notional),'# ##0') as Current_Notional,

       

      But, this did not change a thing !

      What am I doing wrong?