Forum Discussion

ykaja's avatar
ykaja
Frequent Visitor
2 years ago
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...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    2 years ago

    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.

  • ykaja's avatar
    ykaja
    2 years ago

    Thank you AlexisOlson. ROUND function fixed this issue.

ykaja's avatar
ykaja
Frequent Visitor
2 years ago

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.

AlexisOlson's avatar
AlexisOlson
Super User
2 years ago

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.

  • ykaja's avatar
    ykaja
    Frequent Visitor
    2 years ago

    Thank you AlexisOlson. ROUND function fixed this issue.