Formating numerik value as to be pozitif or negati

Comments

• gordk St.Catherines On. Canada.

  March 2006 edited 4:41PM

  use a separate memoview left aligned turn off allow expresions
  write code in obp of band to test datafield value and place appropriate text in the second memoview.
  
• makbolat

  March 2006 edited 4:41PM

  Thank you.
• tuna

  March 2006 edited 4:41PM

  I think this is not a practical solution. I expect sometihing like delphi mask
  for Display format=
  #,###.#0[P];#,###.#0[N];[Z]
  
  if this works it will be more smart
  
  %2.2n[P];%2.2n[N];[Z]
  
  but doesnt supported.
  
• makbolat

  March 2006 edited 4:41PM

  Yes if it s supported it will be really nice.
• tuna

  March 2006 edited 4:41PM

  You can also do like that
  
  [FormatFloat('#,###.##[P];#,###.##[N];[Z]', <frxDataSet1."anumericfieldname">)]
  
  
• gordk St.Catherines On. Canada.

  March 2006 edited 4:41PM

  hi all
  Tuna is correct
  you can also alter the display format formatstring, without using the function.
  ie set display format to number select the last item it will display %2.2m
  delete this value and enter your format string without the ''s
  ie:
  #,###.##[P];#,###.##[N];[Z]
  if you want decimal places to show at all times use 0 in place of # in decimal positions
  #,###.00[P];#,###.00[N];[Z]
• makbolat

  March 2006 edited 4:41PM

  thanks that really nice.