Skip to main content
Solved

Formattig issue

  • January 22, 2025
  • 5 replies
  • 48 views

Hi community,

I need some help with a formatting issue. In a Sales Order report, I am using a subreport to fetch VAT and SVAT values, and the values are being retrieved correctly. However, there is a formatting issue. The numbers are displayed like 1669.18, but I want them to be formatted with thousand separators, like 1,669.18.
 

I tried using ‘#,##0.00’ and ‘SOLine.OrderQty.Format’ to change the value format, but it didn’t work. Does anyone have a solution to fix this.
 

 

Best answer by nhatnghetinh

Hi ​@kviranga38 

Please try using Format    #,##.00

 

Best Regards,

NNT

View original
Did this topic help you find an answer to your question?

5 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 529 replies
  • January 22, 2025

Hi ​@kviranga38 

Please try using Format =[SOOrder.CuryLineTotal.Format]

 

Best Regards,

NNT


  • Author
  • Freshman I
  • 2 replies
  • January 22, 2025

Hi ​@nhatnghetinh 

Thanks for the suggestion. I tried that, but it didn’t work. Do you have any other ideas or suggestions that might help.
 

Best Regards


nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 529 replies
  • January 22, 2025

Hi ​@kviranga38 

I tested and the report worked fine. 

 

Please send your .rpx report file.

 

Best Regards,

NNT


nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 529 replies
  • Answer
  • January 22, 2025

Hi ​@kviranga38 

Please try using Format    #,##.00

 

Best Regards,

NNT


Forum|alt.badge.img
  • Jr Varsity I
  • 61 replies
  • February 11, 2025

Hi @kviranga38,

please try to use the format  #,##.00


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings