Forum Discussion

IF's avatar
IF
Post Prodigy
6 years ago
Solved

negative value in bracket

Hi, I have a column that is called "project". its format is decimal number. I want to show negative values with brackets. I tried to make a measure (Measure=FORMAT([Project];"##,###;(##,###);-") Th...
Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    IF ,

    What is [Project] exactly? Is it Measure or just a fields or Calculated column?

    If it is field from table so try to use aggreagation like SUM,MAX etc.

     

  • Tahreem24's avatar
    Tahreem24
    6 years ago

    IF ,

    Use the below DAX:

    MEASURE = IF(SUM(Sheet6[Value])<0,"("& SUM(Sheet6[Value])&")", SUM(Sheet6[Value]))
     
Tahreem24's avatar
Tahreem24
Super User
6 years ago

IF ,

Use the below DAX:

MEASURE = IF(SUM(Sheet6[Value])<0,"("& SUM(Sheet6[Value])&")", SUM(Sheet6[Value]))
 
IF's avatar
IF
Post Prodigy
6 years ago

Hi,

Thank you very much for the help. it helps. The last issue if you could help: when I put brackets, I don't want to see the minus sign. it should be for example; -3 or (3) However, the sum should be as you showed. For example; (3)+4 sum:1 Is there any possibility not to show the minus value?

 

Regards,

IF