Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hi,
is there a way to format a loss or negative currency value to be in bracket & in red color e.g. ($100) ?
tls: -nik-
Hi,
Have you found the solution yet?.
If not, here is a solution for you. You can change the -100 into (100) for any currency as per below format.
To change it red, just use conditional formatting and use Rules
If your found this heplful, please vote..thanks.
Hi,
You would try to do this with a Measure
Measure:= IF (SUM(Value) <0, "("&LEFT(SUM(Value), LEN(SUM(Value))&")",SUM(Value))
thanks for your reply.
actually, i have this formula for my profit & loss
User | Count |
---|---|
103 | |
87 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |