Using Round() Instead Of Decimal()

Legacy Poster

• 2011年12月12日 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

  モデレータ

  ★ BarTender Hero ★

  • 2011年12月12日 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 ★

  • 2011年12月13日 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

サインインしてコメントを残してください。