Using Round() Instead Of Decimal()

Legacy Poster

• December 12, 2011 12:37

Hi All,
Previously we are using another software to create these Industrial Labels at that time we are able to produce decimal values even if the value is empty in decimal part, i.e if the value=123 and if i use the meathod decimal() then the o/p will be 123.00 And here in Bartender there is no such option Decimal() and we are Using Round() instead of that but i am not able to get decimal value if the decimal portion of the number is having "0" or NULL value.Is there any way to display decimals by default if it is 0 or null.

Thanks,
Phaneendra

Please let me know if you are not clear about what i say.

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • December 12, 2011 17:16
  If you want a number formatted to two decimal places they you should use a VB script to accomplish this.
  
  With a number of some sort in the data source click on the "More Options" button, select the "VB Scripting" tab and then edit the "OnProcessData" event script with something like the below.
  
  [code]value = FormatNumber(value,2)[/code]

  -1
• 

  Legacy Poster

  ★ BarTender Hero ★

  • December 13, 2011 12:35
  [quote name='Ian C - Seagull Support' timestamp='1323710194' post='1298']
  If you want a number formatted to two decimal places they you should use a VB script to accomplish this.
  
  With a number of some sort in the data source click on the "More Options" button, select the "VB Scripting" tab and then edit the "OnProcessData" event script with something like the below.
  
  [code]value = FormatNumber(value,2)[/code]
  [/quote]
  Ian thanks a lot. Its working by replacing round() with FormatNumber()

  0

Please sign in to leave a comment.