
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
add + symbol in front of positive difference
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.
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@ioannagr Num function should be able to do it... just tried this
=Num(10, '+#,##0;-#,##0')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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? 😕

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@ioannagr Yes, number is where you can use your expression

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@sunny_talwar Ok, tried this but no. Maybe
i should put this into Number Formatting expression when custom format is unchecked?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@ioannagr You can use this in your expression, or use it to set as your expression format. +#,##0;-#,##0

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@ioannagr This might then have to done in the expression
If(Expression = 0, 0, Num(Expression, '+#,##0;-#,##0')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@sunny_talwar still +0. I also tried num(0) , still has the +.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- « Previous Replies
-
- 1
- 2
- Next Replies »