SSRS Format currency

Question

Hello,

In MS Report Builder, I try to get columns showing currency formatted like this 8.959.930,44€

When I configure the cell to "Currency", the result is : 8,959,930.44€

I tried to format te cell with this =Format(Sum(Fields!PRIXVENTE.Value), "#.###,00") but the result is : 8959930.44000

Can someone help me ?

Thank you,

Philippe

Answer 1

Hi @Philippe Desmarez,

What the original data looks like? If possible you may provide the sample data and tell us the expected result.

Also you may try below expression to see if it works.

=FormatNumber((CDbl(Fields!PRIXVENTE.Value)),2)

If it does not work, please share the sample data.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.