Calculation groups format negative down arrows

[SamFaM]

Hello, I need your expertise. I'm stuck on this issue with formating. 

Why is there a negative symbol in front of the red arrow with any number larger than -50? the issue is only seen in the numbers larger than -50. Please see the images. 

Thank you for your help! 

[SamFaM]

Hi @OwenAuger   Thank you.

I appreciate the help. We will wait and see if this specific bug is resolved in the future. 

[OwenAuger · Accepted solution]

Hi @SamFaM 

I believe you can get the result you want with this format string expression:

"#,##0.0%;" & UNICHAR ( 128315 ) & " (0.0%);#,##0.0%"

You can make use of the positive;negative;zero structure rather than having to write a conditional expression, and generally a format string expression should produce a format string rather than a value formatted with a format string (using FORMAT).

As to the odd behaviour where only values less than -50% included the "-", I believe this is due to an odd bug where values are "rounded" by some internal calculation before being classified as positive/negative/zero.

Regards