Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |