Member Avatar for Jouni79

how about this sitsuation:

=FormatNumber(Sum(Fields!TotalProductPrice.Value),2)
it returns for exsample following: 1.2345. I need to replace . with ,
how can I do it ?

  • 2 Contributors
  • 1 Reply
  • 87 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by QVeen72
Member Avatar for QVeen72

Hi,

Try This :
=Replace(FormatNumber(Sum(Fields!TotalProductPrice.Value),2),".",",")

Or Change the Local/Regional settings in Control Panel.
For Numbers, Give comma as DecimalSymbol.

Regards
Veena

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.