question

rohitadhumal avatar image
rohitadhumal asked

issue with custom format in ssrs

HELLO , I want to display amount in indian format for eg:"12,20,30,000.00" using custom format in expression like ##,##,##,##0.00 doesn't work. because if i have small value like 25000 i get it in ",,25,000" such format. can anyone help me with ths? (i want to use this expression in ssrs)
report services
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
erlokeshsharma08 avatar image
erlokeshsharma08 answered
=Format(Fields!i.Value,iif(Fields!i.Value>=10000000,"##\,##\,##\,##0.00",iif(Fields!i.Value>=100000,"##\,##\,##0.00","##,##0.00"))) Taken the help from this link:- http://chandoo.org/wp/2010/07/26/indian-currency-format-excel/
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.