Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 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
      6 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
        Super 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")
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.