We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

Negative Number format is not applying if Format as Percentage as true in Number formatting

Closed
Ravi asked on February 2, 2022

Hi,
The Negative Number Format option is not applying if Format as Percentage as true in Number formatting.
 
for more precise, I tried negative number format as below.
negativeNumberFormat: '(1)'
But it didn't get applied
EX: -22.5%, should come like (22.5)%
https://jsfiddle.net/Karthickc/g5uep1r0/10/
 
Thanks
- Ravi

1 answer

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster February 2, 2022

Hello, Ravi,
 
Thank you for reporting such behavior.
 
Currently, applying negativeNumberFormat is only possible for the non-percent values. We have added negativeNumberFormat for the percent values to our customers' wishlist. At this point, we suggest using the workaround with the calculated measure that allows setting negativeNumberFormat. If you create a calculated measure that multiplies the original measure by 100, this calculated measure is an equivalent of the original measure with "isPercent": true. Please check the following example on the JSFiddle: https://jsfiddle.net/flexmonster/kb2s3xuw/
 
We hope it helps. You are welcome to write to us in case further questions arise.
 
Kind regards,
Nadia

This question is now closed