Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Number Format - Total

  Hi all, I need to know how to remove total on the "Number Format"  column    Number Format = IF(SUM('Table'[Number]) = INT (Sum('Table'[Number])), FORMAT(SUM('Table'[Number]),"#,#"), FORMAT(...
General Comment
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Finally its works with 

    Column =
IF (
    Table[Number] = INT ( Table[Number] ),
    FORMAT ( Table[Number], "#,#" ),
    FORMAT ( Table[Number], "#,0.00" )
)

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    much appreciate your reply
    in my "number format " Column's options shown like this,

    • sivapandi's avatar
      sivapandi
      Helper I
      6 years ago

      Hi.,

       

      Check your data type in modeling tab for that particular coloumn. It should not be text . it should be a decimal.

       

      Thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        It's in Text Format because of this

        Number Format = IF(SUM('Table'[Number]) = INT (Sum('Table'[Number])),
        FORMAT(SUM('Table'[Number]),"#,#"),
        FORMAT(SUM('Table'[Number]),"#,0.00"))
        and its a requirement          to fulfill