Personally I would like this feature inbuilt, so I can define them (possibly in the calculation itself)
There maybe something in here > Conditional Formatting of Measure Names/Measure Values
I'm also replying to pick up the thread
First please always mention what version of Tableau you are using whenever posting anything on the forums (unless you are using the latest one). Thanks.
Find a 9.0 workbook attached. This let's you keep the numbers as numbers, but it only works if there aren't any negative values. Custom format formula is:
#,##0.0; ###.# \%
And the calc is:
IF [Type]='N' THEN [CALC2] ELSE -[CALC2] END
NorP - SW.twbx 35.1 KB
it's works. thanks!
I love that trick. Great use of custom formatting!
I will have to remember this.
Wao, It's very maniac
But I love these kind of things.