Forum Discussion
Custom formatting shows empty parenthesis
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.
I think in custom formatting notation, a # drops away if it's zero and I'm guessing the values are small negative numbers that round to zero but aren't actually zero (so the zero formatting doesn't apply).
You could try #,##0;(#,##0);"0", which I'd expect to return (0) instead of () or you could try rounding into the measure.
AlexisOlson The values are whole numbers. So the difference should show '0' as both are same numbers.
Already tried this #,##0;(#,##0);"0" and it returns (0) instead of blank parenthesis.
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.