-
Re: negative number in brackets
Anil Babu Aug 26, 2016 8:08 AM (in response to Robson Candeo)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
-
Re: negative number in brackets
Robson Candeo Aug 26, 2016 8:18 AM (in response to Anil Babu )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%)
-
Re: negative number in brackets
Anil Babu Aug 26, 2016 8:20 AM (in response to Robson Candeo)It's tricky t explain, Can you post sample application which demonstrates the issue
-
Re: negative number in brackets
Robson Candeo Aug 26, 2016 8:48 AM (in response to Anil Babu )thank you. it´s solved
-
-
-
-
Re: negative number in brackets
Sunny Talwar Aug 26, 2016 8:26 AM (in response to Robson Candeo)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
,'+###.##%;(###.##%)')
-
Re: negative number in brackets
Robson Candeo Aug 26, 2016 8:47 AM (in response to Sunny Talwar )thank you but didn´t work
-
-
Re: negative number in brackets
Piet Hein van der Stigchel Aug 26, 2016 8:28 AM (in response to Robson Candeo)Use
Num(YourExpression,'+ ###.##%;(###.##)%')
watch the place of the ) and %
-
Re: negative number in brackets
Robson Candeo Aug 26, 2016 8:47 AM (in response to Piet Hein van der Stigchel )This works. Thank you so much
-