Forum Discussion
Negative Numbers
Hi,
I'm trying to add a minus sign or Parenthesis to the neagative numbers in a measure on my table visual.
Do i need to do it through DAX? beacuse i don't find a way to do it on the report..
This is the muesure:
Change From PM = IF([Total Reports] = [DIFF from PM],BLANK(), [Total Reports] - [Reports Previous month])
Help will be much appreciated!
7 Replies
SHAKEDALROY , refer if this can help
LP2803 for ex - the second line in the Change From PM column is a negative number but it doesn't show it.
it suppused to be -24,986 or (24,986)
Make sure that you are not using ABS (Absolute) in meausre
Hi SHAKEDALROY ,
Can you share your measures to us? There are other rows show negative numbers, the problem may be on the measure.
Best Regards,
jay
