Decimal number format

Answers

• jannestig Member Posts: 999

  2007-12-10

  Where is this display being sent to ? Is it for a report or is it in a form.
  
  If you look at the properties value of the field you can set it to always appear as 2 decimal places which i believe is what you want ?

  0
• monteiro Member Posts: 26

  2007-12-10

  Hi jannestig,
  
  It's a dataport code. I have a DataItem (Customer table). I can't choose the fields properties... see that:
  
  T_LIMITE_CREDITO := FORMAT("Credit Limit (LCY)",0,'<Integer><Decimals><1000Character,.>');
  
  
  Thanks,
  
  Monteiro

  Monteiro, Rodrigo
  www.draeger-medical.com

  0
• jannestig Member Posts: 999

  2007-12-10

  IF you search in Mibuso for Decimal rounding solutions
  
  this one looked llike what you want.
  
  MESSAGE('%1',FORMAT(10000.1,0,'<Precision,2:2><Standard Format,2>'));

  1
• monteiro Member Posts: 26

  2007-12-10

  jannestig,
  
  This is what I was looking for. Thank you so much!
  
  
  
  Regards,
  
  Monteiro

  Monteiro, Rodrigo
  www.draeger-medical.com

  0
• Rishi1109 Member Posts: 43

  2014-07-23

  If you simply change the DecimalPlaces Property of the field in Table then also it will work

  Thanks and Regards
  Rishi

  0
• MichelDant77 Member Posts: 4

  2023-11-09

  jannestig wrote: »

  IF you search in Mibuso for Decimal rounding solutions
  
  this one looked llike what you want.
  
  MESSAGE('%1',FORMAT(10000.1,0,'<Precision,2:2><Standard Format,2>'));

  
  Great, you saved me!

  0