negative values expected output need to show in bracket (5.23%)

[paw1]

Hi All,

Could you please help me on below formatting. For negative values expected output need to show in bracket (5.23%) 

Measure	%SalesValues	expected Output
Sum(Sales)	-5.23%	(5.23%)

Thanks,

[rajulshah]

@paw1 ,

Do the following:

Go to Relationship Editor > select the measure >

In Properties pane > Formatting section > Format > select 'Custom'

Select '$#,##0;($#,##0) ($123,456)'

This should work. Please let me know if this didn't work.