Is it possible to format a number within a calculation?

Follow

Martin Boonzaayer

• July 23, 2015 15:52

For example, to force the number to be displayed with a comma and decimal point. I.e. xx,xxx.xx

0

• 

  Rainer Grabowski

  • July 23, 2015 17:30

  Hi Martin,

  you can format it this way: YourNumber.toFixed(2).replace(/(\d)(?=(\d{3})+.)/g, '$1,')

  Rainer

  0

  Comment actions Permalink
• 

  admin

  • March 22, 2016 02:09

  Hi Rainer,

  I try your above advice but got this result:

  Code:

  var numRealMoney = @Sum of Money spent; //numRealMoney=11000000
  numRealMoney == null ? numRealMoney = 0 : numRealMoney=numRealMoney 

  numRealMoney.toFixed(2).replace(/(\d)(?=(\d{3})+.)/g, '$1,')  

  Result:

  1,1,0,0,0,000.00

   

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • March 22, 2016 14:47

  Hi Admin, try his one: 

  numRealMoney.toFixed(2).replace(/\B(?=(\d{3})+(?!\d))/g, ",")

  You can shorten your code this way: 

  @Sum of Money spent.toFixed(2).replace(/\B(?=(\d{3})+(?!\d))/g, ",")

  Rainer

  1

  Comment actions Permalink

Please sign in to leave a comment.