3 Replies Latest reply: Sep 8, 2017 3:32 PM by Vineeth Pujari RSS

    Round all numbers in Millions to #,##0.00M

    Mandi Hu

      Hi all,

       

      Is there a way to round all numbers in Millions to #,#0.00M by setting it up in Load Script?

       

      I know I could do it in expressions by dividing my numbers by 1,000,000 and assign a format of '#,##0.00M'.

       

      I am wondering can I do this in the script for all numbers so I don't have to repeat actions above in all expressions.

       

      Thank you,

      Mandi