How to diplsy negative values in brackets

[#1]

Hi,

How to diplsy negative values in brackets

(+356) this formate and negative values 456 this formate in the result (356)

                                                                                456 like this only any condition for this

plz help me.

Thanks,

[#2]

On the Number tab of the properties screen select your expression and check Fixed to under Number Format Settings. Set the format pattern to#.##0,00; (#.##0,00)

[#3]

Dear damodark

by using fabs we can convrt nagative to possite

apr sales=- 7000

sum(fabs(apr sales)) it convert to nagative to possitive

[jagan]

Hi Damodar,

Check this URL

http://community.qlik.com/message/290148#290148

Hope this helps you.

Regards,

Jagan.

[#5]

In the "Number" tab of your chart properties select your expression. Then select "Integer" from the "Number Format Settings" and in "Format Pattern" add the following  (+#,##0);  (#,##0)

Hope this helps.