Negative number formatting

[vireshkolagimat]

Hi Guys,

I have attached set of data and i am using straight table to show the data. The source data is in percentage format and i want to show the numbers in percentages and negative numbers in brackets to one decimal places.

I am able to show the numbers in percentages but when i apply the negative number formationg, the values are rounding.

attached is the data set and qvw file for your reference.

Regards,

Viresh

[jonathandienst]

Use the formatting string 0.0%;(0.0%) (assuming your default format uses a decimal point; change to a comma for a decimal comma).

[vireshkolagimat]

Hi, I tried to apply above formatting to the change column but still the result is not changing.

[ecolomer]

In the Numeric label descheck and check option See in %

Look at the file

[vireshkolagimat]

yes i got it. thank you.

[Chanty4u]

try to check here

Rounding Errors

[HirisH_V7]

Hi vireshkolagimath‌ ,

Please close the thread by marking correct answer.

-Hirish

[ecolomer]

Hi vireshkolagimath ,

Please close the thread by marking correct answer.

TX's

Saludos

Enrique