Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Issues with Indian currency value format for negative values

Hi,

 

I am using currency format "English(India)" in one of my dashboards. For negative values, the currency symbol and minus symbol gets moved to the end as shown below . Is there any option to keep the format same for positive and negative values ?

 

 

Thanks,

Mohan

Need Help
  • Gordonlilj's avatar
    Gordonlilj
    6 years ago

    Hi,

     

    If you go into model panel and select the field, you can then go into formatting and switch to custom and change to what you need.

3 Replies

  • Gordonlilj's avatar
    Gordonlilj
    Solution Sage
    6 years ago

    Hi,

     

    If you go into model panel and select the field, you can then go into formatting and switch to custom and change to what you need.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      After choosing Custom field in Format option at model section for specific field/measure, put below format. may be it Works.
      "₹"\ #,0.00;"₹" -\ #,0.00;"₹"\ #,0.00

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    6 years ago

     

     

    you create a calculated column and use the below formaule to get bracket for negative value.

     

    Sales=FORMAT ( [column name]; “##,###;(##,###);-“ )

     

    After that you can use currency function . CURRENCY(table[columnname])

     

    Hope it helps.