Issues with Indian currency value format for negative values

[Anonymous]

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

[rajendraongole1]

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.

[Gordonlilj · Accepted solution]

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]

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