# Display a number in Indian Currency

**URL:** <https://faq.inetsoftware.de/t/display-a-number-in-indian-currency/42>\
**Category:** i-net Clear Reports\
**Tags:** currency\
**Created:** [June 1, 2016, 9:31am UTC](https://faq.inetsoftware.de/t/display-a-number-in-indian-currency/42 "2016-06-01T09:31:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![TorstenRietzel](https://faq.inetsoftware.de/user_avatar/faq.inetsoftware.de/torstenrietzel/32/14_2.png) [@TorstenRietzel](https://faq.inetsoftware.de/u/TorstenRietzel)\
**Post date:** [June 1, 2016, 9:31am UTC](https://faq.inetsoftware.de/t/display-a-number-in-indian-currency/42/1 "2016-06-01T09:31:30Z")

</div>

How can i display a number in the report in Indian currency?  
By default the number is displayed as: xxx,xxx.00. In Indian currency it should be displayed as: x,xx,xx,xxx.00

---

<div class="post-metadata">

**Author:** ![TorstenRietzel](https://faq.inetsoftware.de/user_avatar/faq.inetsoftware.de/torstenrietzel/32/14_2.png) [@TorstenRietzel](https://faq.inetsoftware.de/u/TorstenRietzel)\
**Post date:** [June 1, 2016, 9:34am UTC](https://faq.inetsoftware.de/t/display-a-number-in-indian-currency/42/2 "2016-06-01T09:34:46Z")

</div>

You can display the number in Indian currency using the following user defined function:

```
Function ( NumberVar value )
    If( Abs(value) < 100000) Then (
        ToText( value, "#,##0.00");
    ) Else (
        NumberVar thousands := value \ 1000;
        NumberVar other := Abs( value - thousands * 1000 );
        ToText( thousands,",##") + ',' + ToText( other, "000.00");
    )

```

If the name of the function is IndianCurrency then you can use it in a formula field like:

IndianCurrency( {table.column} );