BEX Formatting for Negative Amount

[former_member209202]

Hi Experts,
I am in requirement where i have to show all the negative amount in a specific format. Please see below the eample. Your help is really appreciated.

Say in BEx the Amount populated is -$5.53. I need to show it in the report as $(5,53).

Regards
Sourav

[Former Member · Accepted solution]

Dear Sourav,

You can achive the Key figure to be shown in  parentheses

Goto Query Properties - Displaying +/- Signs -

Display the value in parentheses

Regards,

Venkatesh

[former_member209202 · Accepted solution]

Hi Venkatesh,
Could you please attach a scren shot if possible.

Regards

Sourav

[Former Member · Accepted solution]

Hi,

I think it display all values in paranthesis.

If correct me if im wrong

[former_member209202]

Hi Everyone,
Thanks a lot for participating in this thread.
Publishing the settings suggested by Venkatesh.

Venkatesh Please confirm if i am correct above.

Regards
Sourav

[RamanKorrapati]

Hi Sourav,

if your in dev or test system. do the above changes and check the results.

one more doubt, user will accept to see the output results in paranthesis?

@ Venkat,

is this applicable to one key-figure? 

As my guess when you apply at query properties it applies to all. sorry if its wrong

if need to specific to KF, then need to do at KF properties.

Thanks

[Former Member]

Yes Sourav , you are absloutly right.

[former_member209202]

Hi Raman,
Thanks for putting your thought into it. To clarify you ..user only wants to see the output results for '-' values in parenthesis.

And you are absolutely right that it is possible at query level where every keyfigure will be affected.

@Vekatesh...Do you think we have any specific option for achieving it at every key figure level.

Regards
Sourav

[Former Member]

No Sourav.This setting will apply on all the Key figure's used in the query.

[Former Member]

Hi,

Just a thought, can you check it using Cell formatting or Workbook formatting?

Thanks.

[Former Member]

Hi Sourav,

I dont think we can acheive this.

Lets wait for other replies