Skip to Content
Author's profile photo Former Member

Financial Values with Rupee (₹) Symbol

Hi All,


I am writing this post to share my project experience.


As per the customers requirement we need to currency in Indian currency format. To achieve it I have search for posts on SCN and I found one which helps me to resolve the Currency format issue.


http://scn.sap.com/docs/DOC-55372


But after showing the financial values as per the Indian standards new question arises “Where is the rupee (₹) sign?”


We have other currency symbols like $, €, ¥ etc. but there is no Rupee (₹) Symbol in list.


To achieve this we dig more and found the solution, that we can use the UTF Unicode format to get this symbol into Web Intelligence Report.


To share this scenario I have created one sample report, It has Total Fare which should be in Indian Currency format.


After creating report I have applied the steps mentioned in (http://scn.sap.com/docs/DOC-55372) to get number format as per Indian Standards.


After this I have applied below mentioned formula to display Rupee Sign before Total Fare.

=Char(8377) + [Total Fare]


Char function will return the character associated with given ASCII code, for Rupee sign it is “8377”. 


Final Output:

Capture.JPG


I hope this will help many developers like me those who are working with Indian clients.

Regards,

Veer

Assigned tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Absolutely helpful.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Niraj 🙂

      Author's profile photo Former Member
      Former Member

      Thank You.It is Helpful  !!!

      I have used some other ASCII Character before but it is helpful for any financial Report.

      Author's profile photo Arijit Das
      Arijit Das

      =Char(8377) + [Measure] will make the number a string.

      I would like to recommend to use custom number formatting option: ('₹'#,##0.00)

      You may notice a box instead of currency symbol in preview but ignore that and continue.

      Required OS update has to be present to support Indian Rupee currency symbol.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Arijit for your inputs....Yes it's working this way too.. 🙂

      Author's profile photo Ganesh Kasar
      Ganesh Kasar

      Thanks for post buddy it is really help full.

      Author's profile photo Former Member
      Former Member

      Thank You. It works