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:
I hope this will help many developers like me those who are working with Indian clients.
Regards,
Veer
Absolutely helpful.
Thank you Niraj 🙂
Thank You.It is Helpful !!!
I have used some other ASCII Character before but it is helpful for any financial Report.
=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.
Thank you Arijit for your inputs....Yes it's working this way too.. 🙂
Thanks for post buddy it is really help full.
Thank You. It works