Hello everyone,
I have a certain measure that shows data in negative value. Is there a way I can just convert it into a positive value/remove the (-) sign?
Thanks everyone!
Hi @Vinod Raju
You have multiple options:
1) If it is only negative, you can multiply evrything by -1
2) You could use the function ABS to get the absolute value.
3) If you want o keep the negative value but not display the symbol, right click on your calculated field, go to FORMAT, then select number (both in your pane and header tabs) and then select custom and add the following number format #,##0.00;#,##0.00
Hope this helps. If this answers has helped you or solved your problem, I would kindly ask you to upvote it or mark it as best answer so other users can refer to it and to acknowledge the effort. Thanks!
Best,
Diego
