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 
    • sivapandi's avatar
      sivapandi
      Helper I
      6 years ago

      Hai.,

       

      Ignore my earlier post...this will work....

      Number Format =
VAR X =
    COUNTROWS ( VALUES ( 'Table'[Custom] ) )
RETURN
    IF (
        X > 1,
        "",
        IF (
            SUM ( 'Table'[Number] ) = INT ( SUM ( 'Table'[Number] ) ),
            FORMAT ( SUM ( 'Table'[Number] ), "#,#" ),
            FORMAT ( SUM ( 'Table'[Number] ), "#,0.00" )
        )
    )

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Finally its works with 

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