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,