How to display brackets for a negative value in Bex Query

[Former Member]

Hi

I have a Production query that is showing -ve values in Brackets like ( 87 ) for -87. But in Dev, I am unable to show the Brackets.

Please advice.

Thanks.

[Former Member · Accepted solution]

Hi,

Open the query in query in Query designer,

Go to query properties->In Display tab> Display of +/- signs -->Select (X)

Hope this helps u...

Regards,

KK.

[Former Member]

Check the kf properties.....r u using any reverse sign.

If you want even you can create a cal kf and make changes as u prefer.

Hide the 1st kf.