formatting currency with negative value

[Anonymous]

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-

[Anonymous]

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.

[Anonymous]

Hi,

You would try to do this with a Measure

Measure:= IF (SUM(Value) <0, "("&LEFT(SUM(Value), LEN(SUM(Value))&")",SUM(Value))

[Anonymous]

thanks for your reply.

actually, i have this formula for my profit & loss

   p&l.all = [total.inc.all]-[total.exp.all]

& if there's a negative value to the result, i'd like the negative-value result(s) to be in bracket & in red color e.g. ($100).

currently, the currency formatting that i'm using is from the general formatting under modelling that doesn't seem to allow what i need & reflected above.

looking forward to that resolution.

tks & krgds: -nik-

[Ahmedx]

You need two measures one for conditional formatting
1)
m1 =IF ([total]>0,FORMAT ([total] , "+0.00%;-0.00%" ),
"("& FORMAT ([total] , "+0.00%;-0.00%" )&")"
)
2)
CF Font =if([total]<0,"#F80000")