12 Replies Latest reply: Jan 11, 2018 11:29 AM by omar bensalem RSS

    Number formatting issue

    omar bensalem

      Hi ALL,

       

      I have a 2 fields as follow:

      Capture.PNG

       

      I want to transform them to percentage %:

      so, this is how I proceed:

       

      but I still have the same result:

      num(num#( [Notional_Variation],'#.##') ,'# ##0,00%') AS [Notional_Variation],

      num(num#( [Threshold_Variation],'#.##') ,'# ##0,00%') AS [Threshold_Variation],

      Capture.PNG

       

      What should I do?