num function add +- before the number

[#1]

Hi All,

I using the num() function in a text object and I would like to add + or - according to the calculation result. The expression is a trend current period in comparison to previous period.

I tried several options including '+#,###' and +'#,###'which didn't work.

Any ideas?

Thx!

Hila.

[maxgro · Accepted solution]

=num(MyNum,'+#,##0;-#,##0')

[Anonymous]

Or even just like this for little less typing :

=num(MyNum,'+#,##0')

[jagan]

Hi,

Try like this using Num()

Syntax: Num(Number, 'Positive Number format;Negative Number format')

Example:

num(-10000,'+#,##0;-#,##0') - Output: -10,000

num(10000,'+#,##0;-#,##0') - Output: 10,000

Hope this helps you.

Regards,

Jagan.

[its_anandrjs]

On text box try like below expression

=if( Sum( YourMetricHere ) <= 0, '-', '+' ) & Fabs( Sum ( YourMetricHere ) )

[#6]

Thx Massimo Grossi! this works great!

[#7]

Hi Jegan,

I wanted to display +1000 for positive and -1000 for negative. See the marked correct answer for the syntax.

Thanks for your help!