Forum Discussion
Hide the operator?
I'm using a measure in a matrix, and for some reason the value is showing the subtraction operator (see the attached image - none of these values are negative, that's the operator). This makes the visual unusuable. How do I remove it? Thanks!
If you want it to always show a postive number regardless of the output, just convert it to an absolute value. Wrap your measure in =ABS()
4 Replies
- edhans
Community Champion
The result of subtracting the MaxYear from MinYear is resulting in negative numbers. The visual isn't showing the operator. It is showing results of the math.
Thank you for your suggestion! The result of the function is displayed in the 'Total' field (which can be negative) - the data in the date rows will never be negative.
.
If I remove the variable filter and shorted it to a CONCATENATE(SUM - SUM) the minus operator goes away, but for some reason when I'm doing a CONCATENATE(SUM,var) - CONCATENATE (SUM,var) the operator is present in the output.
- edhans
If you want it to always show a postive number regardless of the output, just convert it to an absolute value. Wrap your measure in =ABS()
