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" )
)

     

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" )
)