Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

formatting currency with negative value

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-
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

You would try to do this with a Measure

Measure:= IF (SUM(Value) <0, "("&LEFT(SUM(Value), LEN(SUM(Value))&")",SUM(Value))
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Ahmedx
      Icon for Super User rankSuper User
      3 years ago
      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")