negative number in brackets

[rcandeo]

I have a text object that I wanna show as number with % and when it´s negative I wanna it in brackets.

It works if the result is +20.29%, but if the result is (8.85%) it shows (0.09%)

The expression is as below:

=num((

max(Aggr(

(sum({<[Reporting Calendar Year] = {'$(vCurrentYear)'}>} $(vCurrency)) - sum({<[Reporting Calendar Year] = {'$(vPriorYear)'}>} $(vCurrency)))

/

sum({<[Reporting Calendar Year] = {'$(vPriorYear)'}>} $(vCurrency)),

[Broker Pack Region]))

-

max(Aggr(

(sum({<[Reporting Calendar Year] = {'$(vPriorYear)'}>} $(vCurrency)) - sum({<[Reporting Calendar Year] = {'$(vPriorYearBefore)'}>} $(vCurrency)))

/

sum({<[Reporting Calendar Year] = {'$(vPriorYearBefore)'}>} $(vCurrency)),

[Broker Pack Region])))*100

,'+ ###.##%;(###.##%);-')

Any idea what to do?

[Anil_Babu_Samineni]

As i got, If you got +ve value then 12.43%

Meantime, While selection if you got -Ve value then (-12.43%) -- Is this you are expecting? Or What

[rcandeo]

sorry not being more clear. With positive(+) value then works.With negative(-) values it is showing divided by 100, so when should see (12.43%) it shows (0.12%)

[Anil_Babu_Samineni]

It's tricky t explain, Can you post sample application which demonstrates the issue

[sunny_talwar]

How about this:

=Num((

max(Aggr(

(sum({<[Reporting Calendar Year] = {'$(vCurrentYear)'}>} $(vCurrency)) - sum({<[Reporting Calendar Year] = {'$(vPriorYear)'}>} $(vCurrency)))

/

sum({<[Reporting Calendar Year] = {'$(vPriorYear)'}>} $(vCurrency)),

[Broker Pack Region]))

-

max(Aggr(

(sum({<[Reporting Calendar Year] = {'$(vPriorYear)'}>} $(vCurrency)) - sum({<[Reporting Calendar Year] = {'$(vPriorYearBefore)'}>} $(vCurrency)))

/

sum({<[Reporting Calendar Year] = {'$(vPriorYearBefore)'}>} $(vCurrency)),

[Broker Pack Region])))*100

,'+###.##%;(###.##%)')

[stigchel · Accepted solution]

Use

Num(YourExpression,'+ ###.##%;(###.##)%')

watch the place of the ) and %

[rcandeo]

This works. Thank you so much

[rcandeo]

thank you but didn´t work

[rcandeo]

thank you. it´s solved