Forum Discussion
Solved
Custom formatting shows empty parenthesis
A measure is defined as difference of two columns. Custom formatting is defined as #,##;(#,##);"0" . This is mainly to display negative numbers in brackets. For difference of 0, it shows empty br...
Can you try adding ROUND ( ... , 0 ) around the measure you're applying the custom format to? If that fixes the issue, then your problem very likely is that they are small negative values (possibly floating point errors), not actual zeros.
Thank you AlexisOlson. ROUND function fixed this issue.
Can you try adding ROUND ( ... , 0 ) around the measure you're applying the custom format to? If that fixes the issue, then your problem very likely is that they are small negative values (possibly floating point errors), not actual zeros.
Thank you AlexisOlson. ROUND function fixed this issue.