Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Use
Num(YourExpression,'+ ###.##%;(###.##)%')
watch the place of the ) and %
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
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%)
It's tricky t explain, Can you post sample application which demonstrates the issue
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
,'+###.##%;(###.##%)')
Use
Num(YourExpression,'+ ###.##%;(###.##)%')
watch the place of the ) and %
This works. Thank you so much
thank you but didn´t work
thank you. it´s solved