Hide the operator?

[TonyO]

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!

Link to Image

[edhans]

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.

[TonyO]

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 · Accepted solution]

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()

[TonyO]

Thanks Ed, that worked.