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

posted on February 2nd, 2022

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 ⋅ 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