add + symbol in front of positive difference

[ioannagr]

Hello,

when the difference between two measures is negative the minus sign appears but when it's positive the addition sign does not.

I'm asked to present the differences as eg, +10,-10.

How do i put this + ?

I tried with if:

if( (measure1-measure2)>0,'+'&(measure1-measure2),(measure1-measure2)) buuuuuut that's not it.

[sunny_talwar]

@ioannagr Num function should be able to do it... just tried this

=Num(10, '+#,##0;-#,##0')

[ioannagr]

@sunny_talwar  hello 🙂 

Doesn't work. 

Num(number[, format[, dec_sep [, thou_sep]]])  , don't see where i can put my measure difference, where it says number? 😕

[sunny_talwar]

@ioannagr Yes, number is where you can use your expression

[ioannagr]

@sunny_talwar   Ok, tried this but no. Maybe 

i should put this into Number Formatting expression when  custom format  is unchecked?

[sunny_talwar]

@ioannagr You can use this in your expression, or use it to set as your expression format. +#,##0;-#,##0

[ioannagr]

@sunny_talwar  yay! it worked  in the number formatting field, but can I set this for zero not to have +0 to the front? Let it be just 0.

[sunny_talwar]

@ioannagr This might then have to done in the expression

If(Expression = 0, 0, Num(Expression, '+#,##0;-#,##0')

[ioannagr]

@sunny_talwar still +0. I also tried num(0) , still has the +.

[marcus_sommer]

There could be defined a third parameter for zero which could be just 0 but don't need it else it could be also a string, like:

Num(Expression, '+#,##0;-#,##0;0')
or
Num(Expression, '+#,##0;-#,##0;zero')

- Marcus